Hello.

Working on a simple part of code but having trouble.

Have a list of Julian dates in a column and would like to write a loop to go through each, identify the year, month and day with the respective functions, and then concatenate the results into a certain form.

Having a bunch of problems and would appreciate help with any.

1. Currently using this line
Do Until IsEmpty(Range("A3:A").Offset(i.0))
to move down the column - is there any need for .End(xlDown) somewhere here?

2. Am not sure how to initiate a counter to go down through - have something like this for now:
For i=0 to 9
ActiveCell.Offset(i,1)=Y
ActiveCell.Offset(i,2)=M
Next i

3. Finally after I eventually clear those hurdles, do not know how to concatenate the variables properly: Y&M&D do not seem to work.

Thanks!