Vlookup then add copied data to cell on the right

[Macdave_19]

Hi all,

Another annoying problem with this VBA code lark!!

is it possible to use Vlookup to find a value then offset the select cell by 1 colum and paste.

i have some code which checks which week number it currenty is and copies some data, i need it to find the current week then paste the values in the cells to the right.

Please Login or Register  to view this content.

i hope thats understanable folks, sod it ill attach the file!!!

[royUK]

Use the .Find method, lots of examples here and also in the VBA Help files.

[Macdave_19]

As ever roy......you the man...i'll give that a blast

[royUK]

Post back if you need further help with this.