L
Legacy 98055
Guest
Hi everyone!
I've recieved wonderful help here and I doubt this one will be too tough at all.
I have learned how to find the next available row with formulas I have gotten from this room such as .End(xlUp).Row).Rows.Count.
How do I apply this to find the next available column?
I searched and could find no reference to an xlAcross?
The criteria would be the Cell located in row 5 = Nothing to decide if that column is the next column available.
For Example:
If each cell in Range("A5:E5") contained data, but no data in F5, which formula would give me the column number or address of COlumn 'F'?
Thanks again!
Tom
This message was edited by TsTom on 2002-04-09 21:41
This message was edited by TsTom on 2002-04-09 22:37
I've recieved wonderful help here and I doubt this one will be too tough at all.
I have learned how to find the next available row with formulas I have gotten from this room such as .End(xlUp).Row).Rows.Count.
How do I apply this to find the next available column?
I searched and could find no reference to an xlAcross?
The criteria would be the Cell located in row 5 = Nothing to decide if that column is the next column available.
For Example:
If each cell in Range("A5:E5") contained data, but no data in F5, which formula would give me the column number or address of COlumn 'F'?
Thanks again!
Tom
This message was edited by TsTom on 2002-04-09 21:41
This message was edited by TsTom on 2002-04-09 22:37