LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Problem Dropping data in first Empty Cell and across the row



"Sharad" wrote:


Hi,

1. 'MyCellValue = Today' ? Should it not be MyCellCell.Value = Today?

2. Further just after above line, add MyCellCell.Select
Because later you start with ActiveCell.Offset, so the activecell
should be MyCellCell. Therefore you first select it as above.

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Sharad.

Thanks. I'll make corrections and run it again.

Regards.

Ligaya
 
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
Linking 2 worksheets-Empty cell problem NM Excel Discussion (Misc queries) 4 October 1st 08 02:50 PM
problem of an empty cell octet Excel Discussion (Misc queries) 5 September 3rd 08 05:16 PM
Dropping the cell in the empty cell by formula xgunda420x Excel Discussion (Misc queries) 0 February 1st 06 07:11 PM
Macro code for dropping to next empty cell JB2010 Excel Discussion (Misc queries) 4 November 3rd 05 01:35 PM
Copied empty cells, give sorting problem in Data sheet Ruud[_2_] Excel Programming 0 September 16th 04 04:44 AM


All times are GMT +1. The time now is 09:11 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"