Flora Edwards
asked on
VBA to delete all empty cells and move up in usedrange
Hi
i have data and i want to get rid of all empty cells in each columns. i need vba to delete empty cells in columns and move up.
then i have another sheet that also i need delete empty cells but this time move to the left.
thanks.
i have data and i want to get rid of all empty cells in each columns. i need vba to delete empty cells in columns and move up.
then i have another sheet that also i need delete empty cells but this time move to the left.
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I love you Martin.It's a good thing my wife isn't a jealous woman:)
In any case I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
ASKER
Thanks Martin.
your profile is impressive. I liked the Using the Debugger article. it is so helpful.
your profile is impressive. I liked the Using the Debugger article. it is so helpful.
If you want to you can give it a Helpful vote.
ASKER
surely i can and i will
Thanks.
ASKER