Record formulas in VBA from spreadsheet cell

[FryGirl]

I have a spreadsheet with multiple columns. I would like to record all of the formulas into VBA for the sole purposes of restoring those formulas if lost or damaged somehow.

I know I can manually take the steps in VBA by turning on the macro recorder, entering the cells and selecting F2, hit tab and that formula will be written into VBA in the R1C1 format as seen below. Is there a way to automate this to where I can find the last column of row 1 and have this process look thru row 2 starting at A2 and finding a cell with a formula and recording it to VBA?

Sub Macro2()
    ActiveCell.Formula2R1C1 = _
        "=FILTER(Attendance!R4C1:INDEX(Attendance!C1,LastRow),Attendance!R4C2:INDEX(Attendance!C2,LastRow)=1)"
    Range("B2").Select
End Sub

 

[Micron]

Writing code is like writing a letter or similar document in that you do it manually. When you need it, you can use it. You're asking for a way for an application/code to write the letter for you, or put another way, for code to write code. This is possible but very complicated and frankly, not worth the effort. Maybe there is someone around here who is quite experienced with coding at this level but I think it's rare. Far easier for you to keep file backups or store your formulas in a hidden sheet.

 

[FryGirl]

Hi Micron and thank you for your time. I did find a solution on Contextures that will meet my needs.

 

[Micron]

It's customary to post a link to your solution in case anyone reading this in the future could use the info. In that case, you could also mark that post as the solution if you wish.

 

[FryGirl]

Got it. Solution found here.

List All Formulas in Workbook - Contextures Blog

If you're working on a complicated Excel file, or taking over a file that someone else built, it can be difficult to understand how it all fits together. To

contexturesblog.com

 

[Micron]

I misunderstood your issue. I thought you wanted code to write code for you. Sorry.