| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to find last datafield
If the data in the range is always in a single block (that
is, no blank rows or columns), then rng.Cells(1,1).CurrentRegion will give you the part of the range which actually contains data. Regards, Andy Keen -----Original Message----- Hi, how it's possible to find the last datafield in a range where you not known the amount of data. How you can select the data in an xls. Thanks Patrick . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find max value in macro | Excel Discussion (Misc queries) | |||
| Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
| Getpivotdata - able to reference to another cell all parameters but not the datafield | Excel Discussion (Misc queries) | |||
| Show and Hide in Datafield | Excel Discussion (Misc queries) | |||
| Can I pull field as datafield or as a output from a pivot table re | Excel Discussion (Misc queries) | |||
Threaded Mode
