Hi & Hello
I'm in the process of writng my first VBA program for Excel. :yikes:
I have three worksheets, the first is the calculation sheet, the second two are reference sheets which are currently referenced using the VLOOKUP command. Due to the nature of the calculations, the ranges being referenced vary from calculation to calculation, and are very rarely adjacent columns.
How would these be programed into VBA?
[If you need more info then please ask, having not used one of these firmuns before I'm unsure how much data is required....]