Move cursur to the UsedRange

Mar 14th, 2002, 05:01 AM

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.

Mar 14th, 2002, 05:11 AM

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

Mar 14th, 2002, 05:32 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 05:01 AM	#1
Guest Posts: n/a	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.

Mar 14th, 2002, 05:11 AM	#2
Guest Posts: n/a	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

Mar 14th, 2002, 05:32 AM	#3
Guest Posts: n/a	Yes!!!!! Like that What I want, Big Thanks.....Guy