Change from absolute to relative References with Excel Macro.

Hello Bos ? anyone can help me, please..
How to change from absolute references to relative references.

Example :
ws.Range("G" & NextRow).Formula = "=" & Range("H" & NextRow).Address & "+" & ws.Range("I" & NextRow).Address
This code return the absolute references---> =$H$365+$I$365
, and i want change to relative references, like this ---> =H365+I365

Thank's b4

Hi antoni,

Try this:

Please Login or Register  to view this content.

BTW, you'll need to wrap your code (as lecxe and I have done) to comply with Rule 3 of the forum rules (see here for more info)

HTH

Robert

You need to be clearer with your questions.

How do you want to use the formula - add to a sheet or within the code to get a value.

yo bro
if you need to change a range of formulae use

Please Login or Register  to view this content.

example :

Please Login or Register  to view this content.

when i run this code, i get the error here :
Run-time error '1004'
Application-defined or object-defined error.

thank's

try removing the ; and replace it with ,

Please Login or Register  to view this content.

Antoni
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

sir will do..no problems
can you edit your post and add the code tags as advised

I've added Code Tags this time, read the Rules & follow themin future

Please Login or Register  to view this content.