S
SS
Hi,
I am looking for a way to copy a variable range of values.
My spreadsheet has formulas in A1:A100. If conditions are met, values
are displayed, otherwise the formulas return no value, or an empty
looking cell. Of course the empty cells are not blank; they have a
formula.
So, say that A1:A100 have formulas. But only A1:A50 have values
returned (Will always be A1 to ? (up to A100)).
I want to only select and copy A1:A50 (this could be different next
time; that's why it's variable) to another location.
The problem is the method i use always selects A1:A100, because is
sees the 'empty' cells with formulas and includes those as well.
How do i get it to only go the last cell in column A with a returned
value, not the last cell with a formula.
Many Thanks!!
I am looking for a way to copy a variable range of values.
My spreadsheet has formulas in A1:A100. If conditions are met, values
are displayed, otherwise the formulas return no value, or an empty
looking cell. Of course the empty cells are not blank; they have a
formula.
So, say that A1:A100 have formulas. But only A1:A50 have values
returned (Will always be A1 to ? (up to A100)).
I want to only select and copy A1:A50 (this could be different next
time; that's why it's variable) to another location.
The problem is the method i use always selects A1:A100, because is
sees the 'empty' cells with formulas and includes those as well.
How do i get it to only go the last cell in column A with a returned
value, not the last cell with a formula.
Many Thanks!!