How to paste value 5 columns to the right

[Luiz]

Hi, I`m trying to copy a cell and paste value of it 5 columns to the right. I`m trying some solutions from others threads but my 'frankstein' isn`t working.

Here it is:

Explicit Modules

Please Login or Register  to view this content.

I tried using the ".Column + 5" but the excel excluded the "+" ...

Thanks for the help,
Regards,
Luiz

[tehneXus]

This will copy the value of the selected cell to the same row but 5 columns to the right, e.g. A1 to F1

Please Login or Register  to view this content.

Do you need this in a loop for an entire column?

[Luiz]

Hi tehneXus.... thanks a lot. This solved the problem.

No, I don`t need this in a loop.

However, is there a way that I can leave the selected cell in any cell of the same row that I want to copy the A column content and paste it at the F column? I mean, leaving the selected cell at the B, C or D column and copy the A column content to the F column?

Thanks

[tehneXus]

Hi,
like this`?

Please Login or Register  to view this content.

[Luiz]

Yes it`s just what I needed dude....thanks a lot!
Regards