troubleshooting Question

How do I add a date to an inserted line using a macro.

Avatar of Edward Pamias
Edward PamiasFlag for United States of America asked on
Spreadsheets
10 Comments1 Solution123 ViewsLast Modified:
I have a macro that inserts a line but I need to add the weekending date of the previous week after it inserts the line. Column A is where the date would be located. See the macro below to insert a line.

ActiveSheet.Range("A:A").Find("Total To Date", , , xlWhole).EntireRow.Insert
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros