Move cursur to the UsedRange

[Guest]

I don't know it can do or not ,if Activecell is Range F7 and I move to Range EE101 How Can I make Macro to go back to F7.

 

[Guest]

Hi

Try this

Set x = ActiveCell
Range("EE101").Select.
Range("EE101").Value = 777
x.Select
End Sub

If your active cell is F7 the code will select EE101, insert 777 then return to F7

Hope this helps
regards
Derek

 

[Guest]

Yes!!!!! Like that What I want, Big Thanks.....Guy