Vasant,
Thanks for the help. I can play around with this macro and do
everything I need.
Also do you know can you run a macro from a different spreadsheet?
I'm going to be getting a spreadsheet every few weeks and will need to
run this macro against the spreadsheet. I don't want the users to
im
HI,
Hope this helps
pls run the macro "ALign" in the attached file.
Data in "Sheet1" is aligned in "Sheet2". I hv copied the code for your
convenience.
*Sub Align()
Dim Wksht As Worksheet, NWksht As Worksheet
Set Wksht = ThisWorkbook.Worksheets("Sheet1")
Set NWksht = ThisWorkbook.Worksheets("Sh
