VBA - Loop a Copy/paste followed by a Vlookup

[Tcherke]

Hi Excel community,

I am currently doing the following using VBA :

- Copy the coordinates in AW5:AX5 ;
- Paste these in cells B3:B4 on Sheet "Sunset Calculation"
- Then using Vlookup, I retrieve the 'Sunset time' found on the "Sunset Calculation" sheet in column Z based on the date of duty.

I am trying to use this in a loop for the range AW5:AX36, avoiding the blank cells in that range.

I already thank you all for your help on this.

Arnaud

 

[bebo021999]

Pls post your current code, and post a sample mini sheet via XL2BB

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com