Changing range name to new active cell

I need some help please. I hope the following code will explain my problem.

'First, I dim cc as range - then set cc to activecell
Dim cc As Range
Set cc = ActiveCell

'Then I do some steps and then re-select range name of cc
Range("cc").Select 'This works, at least it goes to the correct cell

'Then I select the 4th cell down and this works
Application.Range("cc").Offset(4, 0).Activate

'NOW, I want to set this activecell to be range cc - - - and I can't
get this code to work.

'Every code I try always takes me back to the original range set for
cc.

'CAN SOMEONE GIVE ME THE CORRECT SYNTAX TO MAKE THE ACTIVECELL BE
RANGE cc

Hello Launchnet,

Here is how to do it...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Works great. Thanks very much.

Matt