VBA Range.Formula with IF statement

**Sluggy** · 07-19-2022, 12:15 PM

Hi Everyone -

mKounter = 6
Range("M" & mKounter).Formula = "=If(mKounter=6,=counta("M6:M6"),=counta("M6:M" &mkounter - 1))"

Trying to have VBA enter a count formula, depending on the value of mKounter. If there are no data rows, it should be M6:M6. If data rows are present, then count all rows, M6:M (whatever mKounter happens to be).

Getting: Expected: end of statement error message.

Appreciate any guidance on this.

Thanks,
Sluggy

**WideBoyDixon** · 07-19-2022, 03:10 PM

You need to use code tags around code - it's hard to read otherwise. Regardless, try this:

Please Login or Register  to view this content.

Note that mKounter = 6 creates a self-referencing formula and will probably produce an error.

WBD

**TMS** · 07-19-2022, 03:34 PM

Maybe this:

Please Login or Register  to view this content.

**Sluggy** · 07-19-2022, 04:31 PM

Thanks WideBoyDixon! Appreciate the help!

VBA Range.Formula with IF statement

LinkBack

Thread Tools

Rate This Thread

Display

VBA Range.Formula with IF statement

Re: VBA Range.Formula with IF statement

Re: VBA Range.Formula with IF statement

Re: VBA Range.Formula with IF statement

Thread Information

Users Browsing this Thread

Similar Threads

Applying formula containing if statement to a range using VBA

Hi please help me find a formula for this if statement with range class

Nested If statement formula not working for range of values

[SOLVED] Replace formula in range of cells (with/without if then statement)

[SOLVED] IF statement for Sheet.Range.Formula

[SOLVED] Add IF Statement formula to cells in varying range and paste to used range

Formula to look at range of text and IF statement if values contained in differing range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions