| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the next reference number automatically
Hi
With data in column A, this will return the number of first empty row: FirstEmptyRow = Range("A1").End(xlDown).Row + 1 Hopes it helps Regards, Per "Novicer" skrev i meddelelsen ... Can someone please help me to write a macro that can help me access the next available sequential number (1, 2, 3, 4, etc) from an existing worksheet? For example, if Rows 1 - 5 already has data entered already, I want to reference my formulas to Rows 6 (that is avaialbe) automatically. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to automatically change one number to another number | Excel Discussion (Misc queries) | |||
| Automatically Reference Tab Name | Excel Discussion (Misc queries) | |||
| Column letter reference as number reference | Excel Programming | |||
| tick a reference automatically | Excel Discussion (Misc queries) | |||
| Automatically change tab reference | Excel Discussion (Misc queries) | |||
Threaded Mode
