I have written code to copy data from sheet "Data" (range A1 to last row in Col E) to sheet "classifications"
However , I get subscript out of range and the code below is highlighted in Yellow
Please Login or Register to view this content.
See full code below
Please Login or Register to view this content.
it would be appreciated if someone could kindly assist me
Please Login or Register to view this content.
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.
Thanks for the help. can now see where I went wrong
Hi
The main reason is that you are not copying a range. The last thing you've attempted to do is just identify the last row
However if you're wanting to copy a contiguous range based on A1 then just use the following.
In this situation there's no need to identify the last row.
If that range extends past column E and you only want to copy columns A:E thenPlease Login or Register to view this content.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks for the advise Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks