Though i am not sure but try this Change A2 to A3 in below line
Range("A2").Select in the macro
Sub close_sheet()
'
' close_sheet Macro
'
'
Range("A3").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.ClearContent
Dave, you might want to explain that a bit. Not exactly sure what you are
saying.
On Thu, Apr 25, 2013 at 5:40 AM, David H wrote:
>
>
> I am using an excel spreadsheet in conjunction with Loftware. which
> requires headers in cells A1 and B1. I have formulas in A2 and B2
> calculating data fr
I am using an excel spreadsheet in conjunction with Loftware. which
requires headers in cells A1 and B1. I have formulas in A2 and B2
calculating data from C2 and D2. I'll enter data in columns C & D and then
copy the formula down in columns A and B.
My problem is when I reset the worksh
