Offset Cell content VBA

Hi All,

I am looking for a vba to offset the cells.

The code I have currently is;

Please Login or Register  to view this content.

This is only moving the selected cells across one, however - the content of the cells is what I wish to move so cell C25 has data pointing to another sheet cell A1 i.e. =Sheet1!$A$1 - can I edit this code so it alters the cell to reference B1, C1 etc....

Thanks

Is this one question or multiple? Are you looking to offset cursor from the selected cells or move data of selected cells to a different location or edit cells so that those cells will have a reference (hyperlink kind) to other cells?

I am looking for the cells to remain in C25:D28 and simply edit those cells that reference sheet1 - the hyperlink kind so any given time I offset them it will reference the next column firstly B, then a week later C and so on....

I will do this every Tuesday

Still an example sheet might help

You would need to take out the $ signs in your formula.

=Sheet1!A1

Doesn't work just removing the dollar signs, simply shifts the cell focus along one and cells C25 etc… are still viewing Sheet1!A1

Sheet now attached.

Source data in Completions tab.

Data I wish to edit every Tuesday is in cells C5:D8 and I6 to I9.

I've added both macros separate and wish to combine and if not relevant then skip to the next command please anyone.

bump bump.

Still struggling here.

Please Login or Register  to view this content.

If I understand correctly, below code should work to update C5 to D8.

Please Login or Register  to view this content.

Originally Posted by haripopuri

If I understand correctly, below code should work to update C5 to D8.

Please Login or Register  to view this content.

It's failing on the line in bold above? Run-time error 1004 - Method 'Range' of object '_Global' Failed?

Hi DaveMurray23,
haripopuri's code works for me
also try this

Please Login or Register  to view this content.

This is working great nilem - thanks so much!

Haripopuri - thank you for your input I am going to try and crack yours as well and make sure it's not something I'm doing!

Both of you thanks!!

Originally Posted by nilem

Hi DaveMurray23,
haripopuri's code works for me
also try this

Please Login or Register  to view this content.

Ahhhh it's working for C range but not I range and error message keeps appearing when trying to create a new one for that specific range??

Is this question for me?
Can you show the file where the error occurs

Yes please nilem

The code you gave works perfect for C5:D8 and doesn't give any errors it simply skips updating I6:19

When I then try to create a new one adjusting the range the error comes in this part of the code;

Please Login or Register  to view this content.

Hi DaveMurray23,
Please check the attached file

Thanks so much - working perfectly now!!