Cells.address returning nonsense

[ragtopcaddy via AccessMonster.com]

Why would the following line, when queried in the immediate window (?.cells
(94,1).address) return a value of "$A$187"?

 

[ragtopcaddy via AccessMonster.com]

I was expecting "$A$94", which is, not coincidentally I suspect, 1 less than
2 times 94. Any ideas?

 

[ragtopcaddy via AccessMonster.com]

Sorry for the "new math" ;-)!

What I meant was that the column, 187, in the address returned, "$A$187", is
1 less than 2 times 94, which is the row argument in the .cells function.

Whew! It's been a long day!

 

[Pete D.]

Really long day, you need to post in a MS Excel newsgroup. This is a
microsoft Access Database news group. Sorry

 

[ragtopcaddy via AccessMonster.com]

This is an Access question. I am reporting from Access to an Excel
spreadsheet. The issue at hand, like most Access issues with Excel, doesn't
occurr using the same technique within Excel. It only happens when
manipulating Excel from Access.

Really long day, you need to post in a MS Excel newsgroup. This is a
microsoft Access Database news group. Sorry

Sorry for the "new math" ;-)!

[quoted text clipped - 11 lines]

 

[Pete D.]

Okay, then I'm sorry I don't understand the question. Can you expand on
what you are trying to do a little more, maybe post your code. All I saw as
the excel cell reference and your vba intermediate window. As no one else
has jumped in here I think we need a little more info to give you
suggestions. Pete D.

This is an Access question. I am reporting from Access to an Excel
spreadsheet. The issue at hand, like most Access issues with Excel,
doesn't
occurr using the same technique within Excel. It only happens when
manipulating Excel from Access.

Really long day, you need to post in a MS Excel newsgroup. This is a
microsoft Access Database news group. Sorry

Sorry for the "new math" ;-)!

[quoted text clipped - 11 lines]

(?.cells
(94,1).address) return a value of "$A$187"?

 

[ragtopcaddy via AccessMonster.com]

Pete,

When I type in the immediate window:

?.cells(94,1).address

It returns a value of "$A$187", rather than "$A$94", as I would expect.

Bill

Okay, then I'm sorry I don't understand the question. Can you expand on
what you are trying to do a little more, maybe post your code. All I saw as
the excel cell reference and your vba intermediate window. As no one else
has jumped in here I think we need a little more info to give you
suggestions. Pete D.

This is an Access question. I am reporting from Access to an Excel
spreadsheet. The issue at hand, like most Access issues with Excel,

[quoted text clipped - 9 lines]

 

[Pete D.]

I think you still need to post to excel news group. Although you are
working in access, reference experts for talking to excel will be in that
news group. I'm not anywhere near capable to reference a cell in excel from
access but these folks help us Access folks get there. Reading what you are
trying to do I think it is a minor problem with the reference but I never
really had to do more than import excel to Access. Sorry. Pete D.

Pete,

When I type in the immediate window:

?.cells(94,1).address

It returns a value of "$A$187", rather than "$A$94", as I would expect.

Bill

Okay, then I'm sorry I don't understand the question. Can you expand on
what you are trying to do a little more, maybe post your code. All I saw
as
the excel cell reference and your vba intermediate window. As no one else
has jumped in here I think we need a little more info to give you
suggestions. Pete D.

This is an Access question. I am reporting from Access to an Excel
spreadsheet. The issue at hand, like most Access issues with Excel,

[quoted text clipped - 9 lines]

(?.cells
(94,1).address) return a value of "$A$187"?

 

[ragtopcaddy via AccessMonster.com]

OK, I'll try that. Although it is not obvious to me that I'd be more likely
to find someone with expertise enough in Access to explain why this works in
Excel but not in Access in an Excel group than in an Access group. I should
think a person with such dual expertise would more likely be a denizen of the
Access group.

Regards,

I think you still need to post to excel news group. Although you are
working in access, reference experts for talking to excel will be in that
news group. I'm not anywhere near capable to reference a cell in excel from
access but these folks help us Access folks get there. Reading what you are
trying to do I think it is a minor problem with the reference but I never
really had to do more than import excel to Access. Sorry. Pete D.

Pete,

[quoted text clipped - 17 lines]

 

[Pete D.]

You know, I do this for fun as a hobby and I have never claimed to be an
expert. My suggestion is only to help you. Fact is I played with both for
2 hrs trying to make it work, and could not make it work in excel or access.
This told me you were better than me and I was out of my league or you are
out of your league. I always give favor to the guy trying to make it work,
(refer to hobby above). As an Access entusiest I know when to ask an excel
guy/gal for expertise and it doesn't hurt my ego. Smile and try it, There
are alot of good folks here and in that nasty excel group that have taught
me much. Oh, before you slam expertise, even the Excel folks have asked us
humble Access folks for help once in awhile. Pete D.

OK, I'll try that. Although it is not obvious to me that I'd be more
likely
to find someone with expertise enough in Access to explain why this works
in
Excel but not in Access in an Excel group than in an Access group. I
should
think a person with such dual expertise would more likely be a denizen of
the
Access group.

Regards,

I think you still need to post to excel news group. Although you are
working in access, reference experts for talking to excel will be in that
news group. I'm not anywhere near capable to reference a cell in excel
from
access but these folks help us Access folks get there. Reading what you
are
trying to do I think it is a minor problem with the reference but I never
really had to do more than import excel to Access. Sorry. Pete D.

Pete,

[quoted text clipped - 17 lines]

(?.cells
(94,1).address) return a value of "$A$187"?

 

[ragtopcaddy via AccessMonster.com]

Who's slamming expertise?! What the hell did you read between the lines of my
post that got your panties in a bunch? If I thought my expertise were
superior to that of everyone in this group, I would have never had the need
to post any question here to begin with. I was simply referring to the
likelihood of finding the requisite Access expertise in an Excel group as
opposed to an Access group. I think a little humility might be in order.
There is no one person in any of these newsgroups that has all the answers.

Anyway, thanks for trying. BTW, I tried and failed, too, and I've been doing
this for a living for the last 12 yrs.

Regards,

You know, I do this for fun as a hobby and I have never claimed to be an
expert. My suggestion is only to help you. Fact is I played with both for
2 hrs trying to make it work, and could not make it work in excel or access.
This told me you were better than me and I was out of my league or you are
out of your league. I always give favor to the guy trying to make it work,
(refer to hobby above). As an Access entusiest I know when to ask an excel
guy/gal for expertise and it doesn't hurt my ego. Smile and try it, There
are alot of good folks here and in that nasty excel group that have taught
me much. Oh, before you slam expertise, even the Excel folks have asked us
humble Access folks for help once in awhile. Pete D.

OK, I'll try that. Although it is not obvious to me that I'd be more
likely

[quoted text clipped - 21 lines]