| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate column with variable to set a range
i have a macro which finds the last row and returns the value Last Row. i
want to use this info to auto fill a range - Selection.AutoFill Destination:=Range("B10:B & LastRow"). I get an error message when i try this. should i name the variable LastRow at the beginning of the macro? or is there something wrong with the placement of the quote marks? thanks in advance for your help -- aprilshowers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate cells by a given range | Excel Worksheet Functions | |||
| function to concatenate range | Excel Discussion (Misc queries) | |||
| concatenate a range function | Excel Worksheet Functions | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| Concatenate a range | Excel Worksheet Functions | |||
Threaded Mode
