Generate a flat list of all excel cell formulas

Question

I have a massive program written with VBA and cell formulas. I am tasked to reverse engineer it into C# winforms. I figured for a start, I need to see all the cell formulas in a flat list.

Any existing way to do it? Thanks in advance!

Answer 1

Hello, you'll have to follow certain steps to attain the desired output.

firstly you need to select the row or column that you want to generate

2. now highlight the empty row /column (hit F5 (GoTo) and select Special > Blanks)

3. now type equals, you'll get an arrow up to enter the formula with a direct cell reference to the first data label

4. now don't press enter but hold down the control button and now press enter

5. now you have to generate the formulas or the data, you'll have to select the whole column or row and copy, paste special>values.

this will help u  generate the data