Hey guys im having trouble figuring out how to make a clear form butto
in Macros for my excel spread sheet. It alread contained one the worke
fine until i had to move the from around a bit.

The macro looked like this originally:

Sub clear123()
'
' clear123 Macro
' Macro recorded 12/31/02 by
'

'

Range("D15:E19,G15:G19,G4:J4,G5:J5,G6:J6,G8:J8,G9: J9,K14:N20,R15:U28,K24:N28,D24:G28
_
).Select
Range("D24").Activate
ActiveWindow.LargeScroll ToRight:=2
ActiveWindow.SmallScroll ToRight:=1
Range( _

"D15:E19,G15:G19,G4:J4,G5:J5,G6:J6,G8:J8,G9:J9,K14 :N20,R15:U28,K24:N28,D24:G28,AM8:AM12,AP8:AP12,AN2 4:BA24,AN26:BA26
_
).Select
Range("AN26").Activate
Selection.ClearContents
ActiveWindow.ScrollColumn = 1
Application.Run "SellingcoveragesheetA.xls!sfcsfitscreen"
End Sub

the problem is when i try to adjust ranges like D15:E19 to somethin
less or more the macro dosent work at all. Im not sure how to save th
changes i make or anyting that can help me at this point.

Any advice would be appreciated.

Eri

--
Message posted from http://www.ExcelForum.com