Beginner Macro Question - Selecting all cells?

**mrbenn** · 09-20-2011, 07:17 AM

I have a macro that is designed to work in a particular report .csv and simply reformat it. However the report changes each time it is run and the macro is only formatting the number of rows etc that existed on the version that it was recorded on originally. Obviously the scrolling etc was the recorder tacking on my checking of the report after it was run and is not necessary.

What I need is for the macro to select and reformat ALL active cells in the csv each time, regardless of how many or how few there are in the given instance?

As you may have guessed I am not a programmer in the slightest and have zero knowledge of VBA, I am simply trying to save myself the headache of a boss who keeps asking me to do the exactly the same reformat job every day!

Thanks for any help anyone can give me on this!

S

Please Login or Register  to view this content.

**Richard Buttrey** · 09-20-2011, 07:20 AM

Hi,

Upload your workbook, and in a note describe what you are trying to do with reference to specific cells/ranges

Regards

**mrbenn** · 09-20-2011, 07:27 AM

Wow that was quick!
I have attached 2 files, one is the raw CSV saved as .xlsx and the other is the finished reformat

S

**Richard Buttrey** · 09-20-2011, 08:27 AM

Hi,

Try the attached. It's essentially a blank workbook containing the macros to reformat the .xlsx sheet. Just click the blue button and then choose the file to be reformatted and subtotalled.

Regards

**Richard Buttrey** · 09-20-2011, 08:39 AM

Hi,

It struck me that you might also like to see what a Pivot Table version of this file could be like.

In general Pivot Tables are much more flexible and quickly give you an analysis by the various field names. If you're not familiar yet with Pivot Tables I suggest you might like to play around, dragging and dropping field names wherever you want to see the effect. Your boss may be even more pleased with the greater level of analysis that can be brought.

Regards

**mrbenn** · 09-20-2011, 08:51 AM

wow, thank you so much Richard, I will definitely have a play around with the worksheets you have provided.

So amazingly helpful and so quick too!!

Stephen