Varying data ranges

[melvin]

Hi,

I am preparing a large number of identical reports on Excel fro
imported data of varying sizes (e.g. some imported data is 400 row
long, some 600, but all have the same number of columns). I hav
recorded macros to take the data from its raw form to its complete
form in order to releive the repetitive nature of this process, howeve
the macro does not take into account the varying sizes of the raw data
even when I use the Ctrl+Shft+End command. I am left with a lot o
manual 'tidying up' of the reports after the macros have run.

I have around 1,800 reports to complete so if there is any way roun
this problem or short cut available I would greatly appreciate someon
sharing it with me!!

Cheers folks.

mel

 

[gocush]

Melvin

Please send us the most pertinent part of your macro code and maybe w
can make some suggestion

 

[Harald Staff]

Hi Melv

This should work for "clean" raw flatfile data, assuming no empry rows and
other non-standard interruptions:

Sub test()
Dim R As Range
Set R = Range("A2").CurrentRegion
MsgBox "I guess this is " & R.Address
R.Select
End Sub