excel VBA: cells().address not return with $

cells(1,1).address returns:

$A$1

what is the command that returns:

A1
yws812Asked:
Who is Participating?
 
byundtCommented:
yws812,
Dim myAddr as String
myAddr=Cells(1,1).Address(rowabsolute:=False, columnabsolute:=False)
Brad
0
 
byundtCommented:
Hi yws812,
Cells(1,1).Address rowabsolute:=False, columnabsolute:=False

Cheers!

Brad
0
 
byundtCommented:
yws812,
Thanks for the grade!
Brad
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.