How to use ActiveCell Adress in variable?

**Castor77** · 05-11-2010, 10:03 AM

Hello Gurus!

I've been pounding my head to the wall with an apparently simple problem. I need to store the adress of the ActiveCell in a variable and then use it in Range selection.

Sounds easy but I just keep getting a global error message.

I just need to select an area and copy it. Here is my code:

Please Login or Register  to view this content.

From the immediate window I can see that CellLoc gets the value "I18" but when I try to use it in the range selection I get a global error message.

Any tips are greatly appreciated!

rgds,
cas

**romperstomper** · 05-11-2010, 10:04 AM

Please put code tags around your code or we can't answer (it's a simple fix).

**Castor77** · 05-11-2010, 10:12 AM

Ok, tagged!

**romperstomper** · 05-11-2010, 10:15 AM

You need the variable outside the quotes:

Please Login or Register  to view this content.

**Castor77** · 05-11-2010, 10:18 AM

OMG, I feel quite stupid right now...

Anyway, thank you for your swift reply, great job!

rgds,
Cas

**Marcol** · 05-11-2010, 10:19 AM

Hi Try this

Please Login or Register  to view this content.

Range("B17:" & CellLoc).Select

Okay to late again!

**Castor77** · 05-11-2010, 11:01 AM

Hi,

I'm still wondering... How should the syntax be written when you want to use ONLY variables to declare to range?

Here is an example:

Please Login or Register  to view this content.

Thx!

Rgds,
Cas

**romperstomper** · 05-11-2010, 11:14 AM

Range will actually accept two string arguments:

Please Login or Register  to view this content.

**Castor77** · 05-11-2010, 11:16 AM

Great info!

Thanks again!

-Cas-

**Marcol** · 05-11-2010, 11:28 AM

I think this does what you asked for in your PM

Please Login or Register  to view this content.

I would avoid using ActiveCell.Select altogether but I don't know your actual ranges

Probably better using Find in the Column that has "Result" & "End Result"

Cheers