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.
