Link to home
Start Free TrialLog in
Avatar of Luis Diaz
Luis DiazFlag for Colombia

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:

  1. Best way to loop used range in a specific sheet in order to apply same height
  2. Best way to loop used range of all sheets in workbook.
  3. 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
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Luis Diaz

ASKER

Thank you for this feedback.
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.
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
Add @ character in all cells of all worksheets in activeworkbook.
In every cell that contains Text?
Yes.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Got it, thank you very much for your help.
Pleased to help