Hi Please kindly help,
for below macros is that possible to widened the ranges, now only applied to column AR , I would like the ranges from column AP - AT, thx
Please Login or Register to view this content.
Hi Please kindly help,
for below macros is that possible to widened the ranges, now only applied to column AR , I would like the ranges from column AP - AT, thx
Please Login or Register to view this content.
Hi oeyandyprawira;
Try this:
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
Hi Trebor76,
thx it work to widened the range , but the result is wrong
because on original code is for column AR, when processing column AP code should beand so on when reach column AT will be -41Please Login or Register to view this content.
original code below on column AR
Please Login or Register to view this content.
Last edited by oeyandyprawira; 12-15-2018 at 09:34 PM.
Just need to tweak the column number of the cl variable like so:
Please Login or Register to view this content.
perfect trebor76, thx
You're welcome. Thanks for marking the thread as solved and the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks