View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Changing Cells from Relative to Absolute Reference

I'm not sure if you saw a "thank you" post to one of your and DaveF's (IIRC)
suggestions.

It was something like: Thank you Dave and God for the help....

I thought it may have been a typo, but maybe not...Have you accepted more
responsibility lately??????



Gord Dibben wrote:

I knew that would come back to haunt me.

On Tue, 10 Apr 2007 22:07:34 -0500, Dave Peterson
wrote:

It was a (failed) attempt at humor. I thought correcting, er, changing your
response so that it was incorrect would be funny. But sometimes my humor
doesn't translate into English very well.

Sorry for jumpling in! (Just to get Gord going!)

Roger Govier wrote:

Yes Dave, but on this side of the "pond", in English, you're is a
shortened form of "you are"
Your - the possessive form of you - belongs to you.
<GD&WVVF
--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
I think you meant:

Your not alone.

<gd&r

Roger Govier wrote:

Hi Gord,

You're not alone<bg

--
Regards

Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I just knew someone would question "which" posting considering my
track
record
lately.

I set myself up for that<g



On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish

wrote:

"The" posting? <g

Gord Dibben wrote:
Yeah sure......pick the posting with the spelling
mistake........."formulaws"


Gord

On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson

wrote:


You could use a macro.

Gord Dibben shared this:

http://groups.google.co.uk/group/mic...60f32287258372

or

http://snipurl.com/1g005



PZ wrote:

I know how to use F4 to cycle through reference choices for a
single cell.

Does anyone know how I can do that for a *very* large *range* of
cells? It'll impact something in the neighborhood of 500+
cells.

Thanks, in advance

Phil




--

Dave Peterson


--

Dave Peterson