Good afternoon,
Currently my below macro is incorrectly copying and pasting column x to column t 7 times on my first tab.
I Have a workbook with 15 or so tabs.
I would like for the macro to copy and paste column x to column t one time on each of the below specific tabs:
CB_A
CB_B
CB_C
CB_D
CB_412
CB_617
CB_618
HTML Code:
Last edited by dosydos; 06-05-2020 at 12:02 PM.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Hey dosydos,
So in your 7 specified sheets, in every sheet you want to copy column X to column T of the same sheet ? Also, do you need to copy only or insert a new column ?
yes you are understanding correctly. Copy and insert column on paste.
How about this
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
@nankw83 sorry for delay had a work priority. Macro is working. thank you for providing.
Glad to help & thanks for the reps
i also just realized where my own initial error was. I shouldn't have used range to copy, and instead used ws.columns() to copy.
thanks again for the help
Looking at your code, just another tip that you could use in the future is select case instead of the if or like below
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks