Solved

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

Posted on 2003-12-11
3
1,872 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SuperAntiSpyware Licenses Discounted by 25% !

Exclusive offer to Experts Exchange Members!
Buy SuperAntiSpyware License(s) from us and save 25% on the regular purchase price.
- Includes Full SuperAntiSpyware Vendor Support Entitlements
- Your Subscription does not begin until you activate your license
- Buy for your friends

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

738 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