| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range description
Hello everyone
At present I am using Range("A4:A3000") How can I say Range("A4:A{last non empty cell}") I can locate the cell with Range("A65536").End(xlUp) but how do you write this as a range reference? Kenny |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range description
Hi Kenny
Dim R As Range Set R = Range(Range("A4"), Range("A65536").End(xlUp)) HTH. Best wishes Harald "N E Body" skrev i melding ... Hello everyone At present I am using Range("A4:A3000") How can I say Range("A4:A{last non empty cell}") I can locate the cell with Range("A65536").End(xlUp) but how do you write this as a range reference? Kenny |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Argument description | Excel Discussion (Misc queries) | |||
| =IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5 | Excel Discussion (Misc queries) | |||
| Help and description for UDFs | Excel Worksheet Functions | |||
| Put help/description in formulas (XLA) | Excel Discussion (Misc queries) | |||
| Description box in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
