| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to define range for autofill without knowing the last row .
In Excel Macro i am using, i need to define the range for
Autofill(eg.B1:B5) but the last row defined here B5 can vary with new worksheets. I need to use a formulea to calculate the last row available with data such that it can be used (eg B1: B(=counta(a1:a100)).where counta provides the number of last row to be filled..?? The counta that i tried to use aove does'nt work... Can you HELP..! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hlookup problem in knowing what range to use | Excel Worksheet Functions | |||
| fill in data range knowing start and end values | Excel Worksheet Functions | |||
| Using Autofill knowing row and column number | Excel Programming | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Define Range Name | Excel Programming | |||
Linear Mode
