LinkBack URL
About LinkBacks
I want to apply the code below for Column T without Copy the same codes.
Apply for both Column S and Column T
Any way to do this ?
Thanks in advance .
Please Login or Register to view this content.
I want to apply the code below for Column T without Copy the same codes.
Apply for both Column S and Column T
Any way to do this ?
Thanks in advance .
Please Login or Register to view this content.
Last edited by fluffyvampirekitten; 07-31-2015 at 01:28 AM.
Try changing
For Each rng In Wkb1.ActiveSheet.UsedRange.Columns("S")Cells
to
For Each rng In Wkb1.ActiveSheet.UsedRange.Columns("S:T")Cells
See what happens.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi there,
Assuming the above code works, make this line of code the very first line in your above procedure...
...and this line the very last piece of code in your above procedure:Please Login or Register to view this content.
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
I tried using this method but it doesn't work.Originally Posted by MarvinP
How to do this ?Hi there,
Assuming the above code works, make this line of code the very first line in your above procedure...
...and this line the very last piece of code in your above procedure:Please Login or Register to view this content.
Regards,Please Login or Register to view this content.
Robert
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
I got this run-time error '91':
Object variable or With block variable not set.
Then this was highlightedPlease Login or Register to view this content.
Like I said at the beginning - my examples are based on your code working
From that error message it would seem that the rng variable hasn't been set to anything.
Please don't quote entire threads - only specific parts to support your request.
Good luck with it.
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks