displaying data

crt · May 24th, 2002, 05:46 PM

Its me again,
I have a column where the data will be dispalyed or wont be displayed depending on a condition. How can i find the cell where the data shows up at the very bottom, and put it into a cell near the top

PDuPre' · May 25th, 2002, 12:37 AM

If you know what cell is at the top then select it and then do a Ctrl-Down arrow. It will take you to the bottom of the list of cells.

If you are able to program VBA great. If not, tell me and I will put together something, but I have to run right now.

Philip

crt · May 25th, 2002, 07:05 AM

Thank you for the response. But that takes me to the bottom of my column. Im looking for a way to go to the last cell in a column that contains data. It wont necessarly be the last one.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 05:46 PM	#1
crt New Member Join Date: May 2002 Posts: 11	Its me again, I have a column where the data will be dispalyed or wont be displayed depending on a condition. How can i find the cell where the data shows up at the very bottom, and put it into a cell near the top

May 25th, 2002, 12:37 AM	#2
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	If you know what cell is at the top then select it and then do a Ctrl-Down arrow. It will take you to the bottom of the list of cells. If you are able to program VBA great. If not, tell me and I will put together something, but I have to run right now. Philip

May 25th, 2002, 07:05 AM	#3
crt New Member Join Date: May 2002 Posts: 11	Thank you for the response. But that takes me to the bottom of my column. Im looking for a way to go to the last cell in a column that contains data. It wont necessarly be the last one.