VBA - adjust lookup formulas next to pivot table

[verycoolbreeze]

Hello,

I have some columns with vlookups that are next to a pivot table. When the pivot table refreshes, the number of records can and does change. Instead of manually adjusting my vlookup to the length of the pivot, i would appreciate it is anyone know a way i can set this up in VBA where each time the pivot is refeshed, the vlookup columns get extended or trimmed accordingly.

Thanks in advance for you hep.

Thanks and best regards

Dennis

 

[RSXchin]

you could use CountA or something like that.

 

[verycoolbreeze]

Thanks for your feedback. Anyone else care to give this a go?

Cheers

Dennis