Solved

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

Posted on 2003-12-11
3
1,864 Views
Last Modified: 2011-10-03
cells(1,1).address returns:

$A$1

what is the command that returns:

A1
0
Comment
Question by:yws812
  • 3
3 Comments
 
LVL 81

Expert Comment

by:byundt
ID: 9920591
Hi yws812,
Cells(1,1).Address rowabsolute:=False, columnabsolute:=False

Cheers!

Brad
0
 
LVL 81

Accepted Solution

by:
byundt earned 50 total points
ID: 9920613
yws812,
Dim myAddr as String
myAddr=Cells(1,1).Address(rowabsolute:=False, columnabsolute:=False)
Brad
0
 
LVL 81

Expert Comment

by:byundt
ID: 9920847
yws812,
Thanks for the grade!
Brad
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question