PC Review


Reply
Thread Tools Rate Thread

Change ref type

 
 
Matt
Guest
Posts: n/a
 
      21st Nov 2008
Is there a simple way to change a range of absolute references to
relative?
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      21st Nov 2008
Mat,

Right click your sheet tab, view code and paste this in. Select the range of
data and run the code

Sub Missive()
For Each c In Selection
If c.HasFormula Then
c.Formula = Application.ConvertFormula(c.Formula, _
FromReferenceStyle:=xlA1, ToReferenceStyle:=xlA1, ToAbsolute:=xlRelative)
End If
Next
End Sub


Mike

"Matt" wrote:

> Is there a simple way to change a range of absolute references to
> relative?
>

 
Reply With Quote
 
Matt
Guest
Posts: n/a
 
      21st Nov 2008
Mike, I tried the missive code by selecting the range and running but
the formulas are still showing relative references.

the formulas look like this: ='Nov W3'!E38

Does it matter that the reference is to another sheet?
 
Reply With Quote
 
Matt
Guest
Posts: n/a
 
      21st Nov 2008
Shoot. I got it backwards. I mean relative to absolute ( ='Nov W3'!
E38 to ='Nov W3'!$E$38)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Programmatically change a field of number type to text type GVR_Mike Microsoft Access 1 13th Jun 2006 04:20 AM
Re: change datagridview column type from databound string type to DataGridViewImageColumn? hazz Microsoft C# .NET 0 13th Feb 2006 07:50 PM
how to change all the words of one type(Gunsuh type)to another =?Utf-8?B?bWV0dW1ldmx1dA==?= Microsoft Excel Misc 2 11th Nov 2005 03:29 PM
Windows Media File Type Not Supported. Can't Change Type =?Utf-8?B?dGlm?= Windows XP MovieMaker 1 20th Jul 2005 05:49 AM
when i want to type @ ihave to type" how can i change keys back hedgeslego@aol.com Windows XP Hardware 1 21st Sep 2004 07:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:50 AM.