LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Macro trouble finding 'empty' cells

Hi,
i forgot i had this little problem.
i'm trying to paste data to a specific column, for example- F253.
the problem is, it may not be F253 every time (only now they tell me)

what i think would work is to put a line in before the Paste
that finds the first empty cell in the F column. since there is no
data anywhere underneath, seems possible.
is there such a command line to 'find the first empty cell'?

Thanks for any input,

Have a great day!

SF
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to clean empty cells Dr Hackenbush[_2_] Excel Discussion (Misc queries) 0 March 9th 10 11:55 AM
Finding data amongst empty cells James Excel Discussion (Misc queries) 6 November 10th 09 04:35 PM
Finding days between cells C and L where the cells may be empty Jack Excel Worksheet Functions 1 January 9th 06 06:47 PM
Macro to copy value in empty cells Esrei Excel Discussion (Misc queries) 3 April 19th 05 03:54 PM
macro to delete empty cells Tom Ogilvy Excel Programming 3 August 12th 03 08:06 PM


All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"