| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this range work?
Overall I'm trying to use a variable to set a range so that I can
autofill based on the number of rows in the spreadsheet. I've set SprdshtPosition as an interger. Range("I40000") = "=COUNT(R[-39999]C:R[-1]C)" SprdshtPosition = (Range("I40000") + "1") 'SprdshtPosition will equal only a number ex:3456 Sprdsht_No_Of_Rows = ("A2:A") & SprdshtPosition 'Sprdsht_No_Of_Rows will = A2:A3456 Why doesn't one of the following work? Selection.AutoFill Destination:=Range("A2:A") & SprdshtPosition -or- Selection.AutoFill Destination:=Range Sprdsht_No_Of_Rows |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CTRL A doesn't work on a range of cells | Excel Discussion (Misc queries) | |||
| Cant get dynamic range formula to work. | Excel Worksheet Functions | |||
| SUBTOTAL(9,range) Does NOT work in AutoFilter | Excel Worksheet Functions | |||
| Formatting a range of cells doesn't work | Excel Discussion (Misc queries) | |||
| HELP!! Range selection doesn't work | Excel Programming | |||
Threaded Mode
