Luis Diaz
asked on
VBA: best way to loop sheets & columns
Hello Experts,
I am trying to documenting my various procedures. Could you please advice me with the following questions:
Thank you very much for your help.
I am trying to documenting my various procedures. Could you please advice me with the following questions:
- Best way to loop used range in a specific sheet in order to apply same height
- Best way to loop used range of all sheets in workbook.
- Best way to loop columns related to usedrange in activesheet in order to apply same width
Thank you very much for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Looping through all ells in the UsedRange of all WorkSheets could take a very long time.
What exactly are you wanting to do? If you want to replace a String then you can use Find & Replace
What exactly are you wanting to do? If you want to replace a String then you can use Find & Replace
ASKER
Add @ character in all cells of all worksheets in activeworkbook.
In every cell that contains Text?
ASKER
Yes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it, thank you very much for your help.
Pleased to help
ASKER
I would like to add a 4 point:
4. Loop all cells in used range of all worksheets in order to replace add specific string in all rows.