# \$ large amount of Data.

1. ## \$ large amount of Data.

Hi,
I've been working on quite a large worksheet, and after about 5000 rows, I
realized I forget to hit F4 and \$\$ the referenced cells. Is there a way to
highlight a large area, and have it do the whole thing at once?

Thanks,
Confused Man

2. ## \$ large amount of Data.

Hi!

Take a look at this:

http://tinyurl.com/5pp4q

Biff

>-----Original Message-----
>Hi,
>I've been working on quite a large worksheet, and after

>realized I forget to hit F4 and \$\$ the referenced cells.

Is there a way to
>highlight a large area, and have it do the whole thing at

once?
>
>Thanks,
>Confused Man
>
>
>.
>

3. ## Re: \$ large amount of Data.

Hi,
this example is good but I seriously recommend NOT using cell as a variable
name...it is a reserved word in Excel.

My 2cents..

O

--
Message posted via http://www.officekb.com

4. ## Re: \$ large amount of Data.

confused

Only with VBA.

Sub Absolute()
Dim rcell As Range
For Each rcell In Selection
If rcell.HasFormula Then
rcell.Formula = Application.ConvertFormula(rcell.Formula, _
xlA1, xlA1, xlAbsolute)
End If
Next
End Sub

Sub AbsoluteRow()
Dim rcell As Range
For Each rcell In Selection
If rcell.HasFormula Then
rcell.Formula = Application.ConvertFormula(rcell.Formula, _
xlA1, xlA1, xlAbsRowRelColumn)
Next
End Sub

Sub AbsoluteCol()
Dim rcell As Range
For Each rcell In Selection
If rcell.HasFormula Then
rcell.Formula = Application.ConvertFormula(rcell.Formula, _
xlA1, xlA1, xlRelRowAbsColumn)
Next
End Sub

Sub Relative()
Dim rcell As Range
For Each rcell In Selection
If rcell.HasFormula Then
rcell.Formula = Application.ConvertFormula(rcell.Formula, _
xlA1, xlA1, xlRelative)
Next
End Sub

Gord Dibben Excel MVP

On Sun, 6 Feb 2005 23:59:57 -0500, "confused man" <[email protected]> wrote:

>Hi,
>I've been working on quite a large worksheet, and after about 5000 rows, I
>realized I forget to hit F4 and \$\$ the referenced cells. Is there a way to
>highlight a large area, and have it do the whole thing at once?
>
>Thanks,
>Confused Man
>

5. ## Re: \$ large amount of Data.

O,

Cells is, but cell is not.

HTH,
Bernie
MS Excel MVP

> I seriously recommend NOT using cell as a variable
> name...it is a reserved word in Excel.

6. ## Re: \$ large amount of Data.

Thank you all,

These explanation were a little more technical than I was hoping for. I'm
not too good with VBA, but I bumbled my way through it using your collective

Thanks so much
Confused Man

"confused man" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I've been working on quite a large worksheet, and after about 5000 rows, I
> realized I forget to hit F4 and \$\$ the referenced cells. Is there a way to
> highlight a large area, and have it do the whole thing at once?
>
> Thanks,
> Confused Man
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1