Dim i as Integer
i=1
Do while sheet1.cells(i,1) <> ""
sheet1.cells(i,2)=sheet1.cells(i,1)
i=i+1
Loop
End sub
I just wrote that. For you, my little end sub.
Back in college, poring over Dikensian tomes, visual basic was about the last thing I invisioned in my career future. But here I am, and to be honest they assign me a lot worse and I'd still stay on. Because I'm not just learning visual basic. I'm learning visual basic in Ireland.
And learning stuff like this never hurt a person.
Aaand....if you know me at all, you know that secretly I'm really enjoying learning something challenging, even if I will be whinging about a little it at lunch today with Fiona. :)
Back in college, poring over Dikensian tomes, visual basic was about the last thing I invisioned in my career future. But here I am, and to be honest they assign me a lot worse and I'd still stay on. Because I'm not just learning visual basic. I'm learning visual basic in Ireland.
And learning stuff like this never hurt a person.
Aaand....if you know me at all, you know that secretly I'm really enjoying learning something challenging, even if I will be whinging about a little it at lunch today with Fiona. :)
i'm not a big fan of that shade of maroon/dark red but i like the blue.
ReplyDeleteas for my blog i love green, it was needed.
no hard feeling