How to use a cell formula with a lot of quotes in VBA

[Nothnless]

Hi, here is the exact formula I am using in a cell, it works perfectly.

=" #""Filtered Rows1"" = Table.SelectRows(#""Sorted Rows"", each true),"

How can I assign the above formula to a cell using VBA?

I tried the obvious:
Sheets("Sheet1").Range("A36").Formula = "=" #""Filtered Rows1"" = Table.SelectRows(#""Sorted Rows"", each true),""

But I get errors.

 

[Joe4]

One easy way to get the VBA code you need is to do the following:
Turn on the Macro Recorder, and then record yourself manually entering the formula into a cell.
Then stop the Macro Recorder, and look at the VBA code you just recorded. It will show you what that formula would look like, being entered through VBA.

 

[Nothnless]

One easy way to get the VBA code you need is to do the following:
Turn on the Macro Recorder, and then record yourself manually entering the formula into a cell.
Then stop the Macro Recorder, and look at the VBA code you just recorded. It will show you what that formula would look like, being entered through VBA.

So easy, I can't believe it. Almost forgot the macro recorder even exists. THANKS!!

 

[Joe4]

You are welcome.
It comes in real handy in these instances. Let Excel do all the heavy lifting!