How to put content of active cell in variable?

**obgle** · 09-20-2012, 12:01 PM

Hey there,

I would like to know how I can put the content of the active cell, I go to with this loop, in a varaible.

Please Login or Register  to view this content.

When I proceede with something like:

Please Login or Register  to view this content.

my variable "cvalue" contains the position of the active cell but not the number that is in that cell.

Does anyone knwo how to fix that??

THX, Obgle

**mike7952** · 09-20-2012, 12:05 PM

Try this

Please Login or Register  to view this content.

**obgle** · 09-20-2012, 01:04 PM

Hey Mike, good to see you again ;-)

Thanks alot for your answear, unfortunately the value of cvalue is always "0" with your code. Might there be a problem with the formate of my numbers? They al look like this: 11-3401-9970-1-92

Thanks, Obgle

**mike7952** · 09-20-2012, 01:38 PM

Give this a try.

Please Login or Register  to view this content.

**mike7952** · 09-20-2012, 01:41 PM

Hey Germany,

Didnt realize it was you.

**obgle** · 09-20-2012, 01:53 PM

Yap, it's me :-)

And you solved my problem... again! Genious!

**obgle** · 09-20-2012, 02:00 PM

Hey one more Question:

What is Debug.Print doing?

**mike7952** · 09-20-2012, 02:08 PM

It prints to the Immediate window inside the VBE Editor. Instead of me trying to explain heres a Good link that will tell you all about it.

http://www.cpearson.com/excel/debug.htm