Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Picking up the last non-empty cell in a given range
I have given a range (say a1.a100 which contain IF function in every cell) to
my users. They are to enter value into the cell everyday continuously. Can anyone help me with VBA codes for me to pick up the last entered value (say A42, A43 onwards are still empty) on anyday, to be linked to another workbook? I used the SpecialCells(xlCellTypeLastCell) feature, it doesn't work. It always return A100, possibly because A100 contains an IF statement. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
place empty cell with zero | Excel Worksheet Functions | |||
Is there a way to go to next empty cell in a formula | Excel Worksheet Functions | |||
macro to look for empty cell | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel |