doesn't recognize the variable

Why doesn’t it recognize the variable iUniqIdCells?

WORKS: Range(Cells(2, iCurntCol), Cells(iLastRow, iCurntCol)).Select
FAILS: Range("iUniqIdCells").Select

I want to count the entries in Range W2:W89 and put the total into W1
My ActiveCell.Formula doesn’t work

Please Login or Register  to view this content.

Hello Carstowal,

This code will place the COUNTA formula in W1 using the cells W2 through W89.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

the " " marks are messing it up

I don't understand what your code is doing but it puts the argument in ""
=COUNTA("$W$2:$W$89")in W1

which returns 1 (it should return 33)
and it would return 33 if the " " was omitted from the formula, yielding =COUNTA($W$2:$W$89) in W1

what does Addx = Chr$(34) & Selection.Address & Chr$(34) mean?

Hello Carstowal,

My apologies for that. I should have checked the COUNTA argument type. Use this code instead...

Please Login or Register  to view this content.

Sincerely,
Leith Ross