try this
Sub reset()
Dim Lrow As Long
lastrow = Range("C" & Rows.Count).End(xlUp).Row
Range("a3:d" & lastrow).Clear
Range("c2:d2").Clear
End Sub
Sub applyformula()
Dim Lrow As Long
lastrow = Range("C" & Rows.Count).End(xlUp).Row
Range("A2:B" & lastrow).FillDown
End Sub
On Fri, Apr 26, 2013 at 7:11 AM, David H <[email protected]> wrote:
> Thank you for the tip. Moving to cell A3 works, except when my only data
> is in C3 & D3. My goal is to reset the worksheet without the users losing
> the formulas.
>
> On Wednesday, April 24, 2013 8:10:58 PM UTC-4, 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 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 worksheet, my formula wants to copy the
>> header into cells A2 & B2 instead of the formula.
>> Here are the macros I am using.
>>
>> Sub copydown()
>> ' create_labels Macro
>> ' makes spreadsheet for BSI labels
>>
>> Dim Lrow As Long
>> Lastrow = Range("C" & Rows.Count).End(xlUp).Row
>> Range("A2:B" & Lastrow).FillDown
>> End Sub
>>
>> Sub close_sheet()
>> '
>> ' close_sheet Macro
>> '
>>
>> '
>> Range("A2").Select
>> Range(Selection, Selection.End(xlDown)).Select
>> Range(Selection, Selection.End(xlToRight)).**Select
>> Selection.ClearContents
>> Range("C3").Select
>>
>> End Sub
>>
>> Can anyone help.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/151803898222297>
Join Us on Facebook <http://www.facebook.com/groups/163491717053198/>
P Before printing, think about the environment.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
