Hi All,
I want to knew the mistake which I am doing when reading the values from B6 cells and manipulate it using VB script. As mentioned in the example below:
Attachment.png
The code which I am using is
[B]Can you please let me know the mistake in this code.
Please Login or Register to view this content.
With Regards,
Giriesh M
Last edited by Giriesh; 12-27-2013 at 04:05 AM.
should be
ActiveSheet.Cells(6, 2).Value <> " " Then
or
ActiveSheet.Range("B6").Value <> " " Then
Post deleted
Last edited by Winon; 12-27-2013 at 04:23 AM. Reason: Code tags added as requested
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Sadath,
Even after changing the code as you mentioned it is throwing the error.
With Regards,
Giriesh M
Hello Giriesh,
Please could you upload a sample Workbook, complete with your code, and showing us how you would the outcome to look like? I appears to me that you want to insert a Row somewhere if B6 is empty.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks