I am new to VBA macros and attached is the code that i have tried but get a runtime error 9: subscript out of range. Can anyone help. The first cell to copy is in 1st worksheet cell A5 (if has data) and it will also be copied to cell A5 (if empty) in 2nd worksheet. Below is my code:
Thanks for your help
Please Login or Register to view this content.
Last edited by Fotis1991; 05-27-2014 at 10:24 AM. Reason: pls use code tags around your codes
I can't determine what you're trying to do from your description and code. Could you better explain? The title says you want to copy an empty cell. I doubt you really want that.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Sorry, that would be pretty silly, let me try and clarify. 1st spreadsheet "ICU" may have date in cells A5 to A29 (all cells are 3 rows combined i.e. a5,a6 and a7 are combined in A5). I want to copy the first cells with data to the first empty cell in column A in 2nd spreadsheet "CAPU summary" -beginning in A5 (these cells also have 3 rows combined). I then want to continue copying the next cell in column A spreadsheet "ICU" to the next empty cell in column A in spreadsheet "CAPU summary".
Try this...
Please Login or Register to view this content.
When I run this macro, nothing happens. There is no copying from "ICU" to "CAPU Summary". I believe that I have copied the code correctly.
Thank-you, I was able to utilize this code to solve my issue. many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks