Offsetting

Hi ozgrid, is there any vba code that i can use to dervice the location from cell H2 and then offsetting it by 3 columns?

Ie. If the contents in cell H2 is $a$3 , i would like to output a text in cell D3? Thank you in advance!

Quote from Fluff13

How about

Code

    Range(Range("H2").Value).Offset(, 3).Value = "Text"

Hi Fluff13 excel recognizes it as a text and not as a cell address hence im unable to do that therefore im looking for other alternatives that allows the cell address to be recognized as a cell address.

Quote from Fluff13

Have you tried it, as it works for me when H2 is this formula

=ADDRESS(MATCH(H1,A:A,0),1)

Hi i recieved this error upon placing the formula in. May i know if your format is in R1C1 format?

Quote from Fluff13

Have you tried it, as it works for me when H2 is this formula

=ADDRESS(MATCH(H1,A:A,0),1)

If its possible could you please post your excel file here? Thanks!

Quote from Fluff13

What did you change the formula to? You already had a formula in there.

There was a typo error my bad however Range(Range("H2").Value).Offset(, 3).Value = "Text" still does not work if it works for you could you please post your excel file here thanks!

Quote from Fluff13

I don't have a file, can you post the entire code your using?

Hi attached is the file i have tried to place the code in the sheet vba editor however it dosent work do work on this file and let me know if your method works!

Quote from Fluff13

The reason it doesn't work is twofold

1) you have changed the formula in H2 to return an R1C1 style address, change it back to an A1 style address.

2) you have not used the code I suggested.

Hi i have rectified the issue thank you very much!