formating data once

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole Seibert - 20 Mar 2006 20:00 GMT

Question: Is there any way to set the formatting once (e.g. for row height,
and column width) so that when I transfer data into 100 or so different
user's sheets it all looks the same? I am trying to avoid cutting and
pasting the 20 or so lines of column/row formatting into the 100 or so sheets
of user interface.
Thanks,
Nicole

Reply to this Message

Candyman - 20 Mar 2006 20:33 GMT

This is one example:
For i = 1 To Cells(8, 1).CurrentRegion.SpecialCells(xlCellTypeLastCell).Row
Sheets("Target").Columns(i).ColumnWidth =
Sheets("Source").Columns(i).ColumnWidth
Next i

Hope it helps.
Candyman

> Question: Is there any way to set the formatting once (e.g. for row height,
> and column width) so that when I transfer data into 100 or so different
[quoted text clipped - 3 lines]
> Thanks,
> Nicole

Reply to this Message