Appreciate the explanation on 'Option Explicit' and I have corrected
the "/" error. I usually know what I want but many times have a hard
time explaining to someone else what I want!
I want the program to use the ticker in A6 and the date in B6 and run
my code. Then use A6 with B7. Then A6 with B8. This will continue
until there is a blank cell in column B.
Then use A7 with all available B's. Then A8 with all available B's.
And so on until there is a blank cell in column A.
I tried to do just one loop. I was trying to start using cell A6 & B6
and work my way down column A until I reached a blank cell.
For my 'counter' I tried to use;
ticker = Worksheets(" Sheet1"). Range("A6" ).Value
Do While ticker <> ""
ticker = ticker + Offset(1, 0)
I get an error message with the Offset highlighted in Blue. The 'Help'
tell me I have a Sub, Function, or Property not defined. Could you
tell me where I'm going wrong here?