M
melvin
Hi,
I am preparing a large number of reports of varying size on Excel (e.g
some data ranges are 400 rows, some 600, but all have the same numbe
of columns). Because the data groups are constantly varying, I hav
used the Autoformat function on a macro so that all the data i
selected and formatted regardless of the range. Unfortunately, none o
the arrangements available on Autoformat are entirely suited to th
rest of the report.
Is there any way of creating your own Autoformat arrangement?
Alternatively, is there any way of recording a macro to take int
account varying data ranges?
Harald & gocush: I tried using the VB code you sent me, however I am
little unsure where to place it in the code. I have attached part o
my macro it will help to take a look.
Many thanks for your continuing support.
Kind regards,
Mel
+----------------------------------------------------------------
| Attachment filename: autoformatmacro.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=370940
+----------------------------------------------------------------
I am preparing a large number of reports of varying size on Excel (e.g
some data ranges are 400 rows, some 600, but all have the same numbe
of columns). Because the data groups are constantly varying, I hav
used the Autoformat function on a macro so that all the data i
selected and formatted regardless of the range. Unfortunately, none o
the arrangements available on Autoformat are entirely suited to th
rest of the report.
Is there any way of creating your own Autoformat arrangement?
Alternatively, is there any way of recording a macro to take int
account varying data ranges?
Harald & gocush: I tried using the VB code you sent me, however I am
little unsure where to place it in the code. I have attached part o
my macro it will help to take a look.
Many thanks for your continuing support.
Kind regards,
Mel
+----------------------------------------------------------------
| Attachment filename: autoformatmacro.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=370940
+----------------------------------------------------------------