Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
I've stumped myself yet again.
I have a cell named "bounce" that will provide the column, and the row I can determine using Activecell.row. The column will constantly be changing as I will be adding columns now and then, hence the named range.
What I can't figure out is how to put them together to make a usable cell address.
I only need to come up with this so I can use an end(xltoleft) command to get to the last row of my data--I tried doing this the "easy" way of just whatever row has the currently active cell and doing an xltoright, but there are some blanks in the data here and there and it buggers it all up.
Any thoughts?
Thanks
(Note: I most likely won't be able to reply until Dec. 1 when I'm back at work with the file in front of me)
I have a cell named "bounce" that will provide the column, and the row I can determine using Activecell.row. The column will constantly be changing as I will be adding columns now and then, hence the named range.
What I can't figure out is how to put them together to make a usable cell address.
I only need to come up with this so I can use an end(xltoleft) command to get to the last row of my data--I tried doing this the "easy" way of just whatever row has the currently active cell and doing an xltoright, but there are some blanks in the data here and there and it buggers it all up.
Any thoughts?
Thanks
(Note: I most likely won't be able to reply until Dec. 1 when I'm back at work with the file in front of me)