Hi all
In the attached...If user selects D2:F25 as RefEdit selection...I need code that resizes the range to populated column only...
i.e E2:E25
Please Login or Register to view this content.
Hi all
In the attached...If user selects D2:F25 as RefEdit selection...I need code that resizes the range to populated column only...
i.e E2:E25
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Couldn't you use SpecialCells(xlCellTypeConstants)?
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks JLGWhiz...
Just perfect...
Have slightly adjusted file allowing for a blank value in [E13]...
Still need E2:E25 as result
EDIT....
Not to worry...Tx...Was not thinking lol...
Please Login or Register to view this content.
Last edited by sintek; 09-20-2018 at 03:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks