copy to empty column starts with column E
Good day to all,
im newbie on this vba and excel
i have this problem and search through the internet and try to compile but cant get fix the code the exact way i want
i like to paste a manually selected columns from sheet1 and paste to range E5 if not empty
an example is like this
i manually select a range of columns and if i press a command button it the range of column will be copied to sheet2 range E5 if not empty.
my code
Please Login or Register to view this content.
Hi, dragavs,
if you are working with Worksheets and Ranges/Cells you would need to use Set in order to build an object to these. I´m assuming you would like to add further information to the next available column:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
thank you for the quick answer HaHoBe the code is perfect.
Re: copy to empty column starts with column E
final code
Please Login or Register to view this content.
i have this code and i like this to add a code that will group the rngToCopy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks