Use VBA to Autofill a Row until the end of the number of data in another row
Hello, I need some help with the following problem: The Macro should select the first cell with the vlookup (AY2) and autofill the complete range in the column AY until the last row that contain data in the cell next to it (Column E). Column E is the cell that the vlookup refers to. The situation looks like this: The code that I have so far looks like this: Sheets(3).Select Range("AY2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-41],DennisAR!C[-50],1,0)" Selection.AutoFill Destination:=Range("AY2:AY1662") Range("AY2:AY1662").Select The problem with this is, that the number of rows with data always change every week. So I cannot use a static row number of 1662. I am looking for a way to make Destination:=Range("AY:AY1662) dynamic. In fact it has to refer to the number of rows with data in column E. Thank you very much in advance, KaiVBA to Create Named Ranges
Hello! I am trying to create named ranges in Excel using VBA, but I'm not sure how I would do this when the cell/row range varies. I want to use the module on different excel files. I want the module to create a named range under specific words such is "Calls","Full Name", etc.
Simple List of Combinations From Single Row Table
Note: Novice User, using Excel 2013. I want to create a non-repeating list of possible combinations/permutations from a single column table. I want to make a simple table called "letters". The number of items will vary. I'm using alphabet characters in the example but imagine these could be easily apples, oranges, salad, drink....and so on. In a separate tab I want to generate a list of non-repeating combinations, order does not matter, and I want to run this list in varying string length (1x, 2x, 3x, 4x, ...) until final result with all items combined. Sample output I imagine would be: A B C D AB AC AD BC BD CD ABC ABD BCD CDA ABCD If possible from formatting perspective, I would like to display the combinations separated by "+" character. Any help would be appreciated.
Conditional Formatting based on the date of another column
Hi, I'm trying to conditionally format cells in column A based on their related to cells of the same row in column J. Essentially if the date in column A is before the day in column J I want the cell to go green If the date in column A is after the date in column J I want the cell to go red Is this possible? I cannot find a way to do it.
Formula language problem
Hello, I'm from Switzerland and we speak 3 different languages. Mine is french but the most important is german. I use excel online, the menu is in french, no problem. But when I want to enter a formula, I have to type it in german. That's a problem for me. I didn't find how to change it. Please help me. Thanx Fabrice
Excel Bing Map Chart - Zoom on a Region
Hi, I'm working with Map Charts with dynamic data filtered using a slicer, the map area in the series options is set on Automatic. I want to force excel, also using VBA, to zoom on the area where data are not null. In the attached case the map is not zoomed on the entire Europe because Turkey and Israel are considered as european countries. If I set them in the Middle East region I only shift the problem there. Do you have any suggestion to fully visualize the desired region? Is there the possibility to utilize VBA code to force the map area? Thank you in advance for any clarifiaction. Marino
