I have a table which has formulas throughout. In the past to find the end of a table I used
Range("A2").End(xlDown).Select or
Range("A65536").End(xlUp).Select depending on the occasion. The problem I am having with these at the moment is that this code finds the last cell with a formula where as I specifically want the last row that has returned a value. Any ideas?
Range("A2").End(xlDown).Select or
Range("A65536").End(xlUp).Select depending on the occasion. The problem I am having with these at the moment is that this code finds the last cell with a formula where as I specifically want the last row that has returned a value. Any ideas?