find next blank cell

p please bob · May 23rd, 2002, 03:15 PM

I have a range of info, that varies daily, I need to highlight and copy the info plus the next blank cell below the range.
I currently copy the data using ctrl+shift+down arrow.

Any suggestions/alternatives gratefully received

Damon Ostrander · May 23rd, 2002, 03:47 PM

Hi p please bob,

To add the next blank cell to your selection after doing the Ctrl-Shift-Down Arrow, just lift you pinkie off the Ctrl key and press the Down Arrow again.

p please bob · May 25th, 2002, 06:07 AM

Damon,
thanks a lot, it was starting to drive me mad !!

May 23rd, 2002, 03:47 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi p please bob, To add the next blank cell to your selection after doing the Ctrl-Shift-Down Arrow, just lift you pinkie off the Ctrl key and press the Down Arrow again. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

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

May 23rd, 2002, 03:15 PM	#1
p please bob New Member Join Date: May 2002 Posts: 19	I have a range of info, that varies daily, I need to highlight and copy the info plus the next blank cell below the range. I currently copy the data using ctrl+shift+down arrow. Any suggestions/alternatives gratefully received

May 25th, 2002, 06:07 AM	#3
p please bob New Member Join Date: May 2002 Posts: 19	Damon, thanks a lot, it was starting to drive me mad !!