implement letters

**benedictexcel** · 01-30-2012, 12:14 PM

Hi
I'm looking on a way to implement letter so I can search through a worksheet with VBA.

ex:

letter = "A"
while letter <> "Z"
letter = letter+1 (that would make letter = "B")
sheet2.range(letter & 1).value = sheet7.range(letter & 362).value
wend

That's the main idea, it's not as simple as that, but I hope you get the idea about what I want!
Thanks a lot

Benedict

**benedictexcel** · 01-30-2012, 02:37 PM

Hi
Found the way to do this, using chr(ASCII)
the letters have their own ASCII number. So the way i found is converting the number into it's ASCII value usng the chr() comand.

**tigeravatar** · 01-30-2012, 05:53 PM

benedictexcel,

I'm a bit confused, why wouldn't you just use the below?

Please Login or Register  to view this content.

**benedictexcel** · 02-09-2012, 10:29 AM

I wouldn't use this formula because I must skip one row every now and then. Also i simplified the idea so it would be easier to understand. I needed to do a few actions before copying the cells.