From the below code i am able to auto fill individual columns. Can we edit this to select a range of columns? (i.e) Range of B and C column have to autofill instead of B column alone and the E column need not to be changed. This is because i have more than 20 columns to drag. so if i replicate this code for all the columns then the macro will result in a very lengthy script and makes hard to edit
Please Login or Register to view this content.
Since the only way to "SELECT" columns if for that sheet to be onscreen, I've removed the "ws" stuff. So something like perhaps?
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks