Macro help!

[Meadowhall]

Hi

I did a search and didn't find anything similar, so I'm sorry if it's a repost.


I'm a complete n00b when it comes to Excel, so I apologise in advance!
I'm working with a spreadsheet that uses a Macro to select data. The problem is that it is set to select everything from that button (about row 10) until row 850, and this current spreadsheet only has data until row 799. There's an extra 51 rows that it's selecting that have no data in (and is filled in with zeros).
I would just change it to select until row 799, but the data is constantly changing and next time might be until row 830 (and being set to 799 wouldn't include that data).


This is the Macro:

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 10/11/2005
'

'
Range("A11:J11").Select
Selection.AutoFill Destination:=Range("A11:J850"), Type:=xlFillDefault
Range("A11:J850").Select
End Sub


Is there any way of only selecting the data until where it ends? The last row I need to select is the Grand Total line; is there some way of tying it into the Grand Total formulas?

Thanks for any and all help!

M

 

[Meadowhall]

Any help would be greatly appreciated!

 

[SteveO59L]

Range("A11:J11").Select
Selection.Copy

Range("a11:j" & Range("j65536").End(xlUp).Row).Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False