Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine activecell and move to it after running ohter sub...
Hi.
I need to determine the activecell at some point and move to it after other sub as run. how can i do this? i´ve tried the following without success... r = ActiveCell.Row c = ActiveCell.Column Run "Formatar_fundo_original" Range(c & r).Select Thanks SpeeD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine activecell and move to it after running ohter sub...
Try using
Cells(r,c).Select -- Regards, Nigel "SpeeD" wrote in message ... Hi. I need to determine the activecell at some point and move to it after other sub as run. how can i do this? i´ve tried the following without success... r = ActiveCell.Row c = ActiveCell.Column Run "Formatar_fundo_original" Range(c & r).Select Thanks SpeeD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine activecell and move to it after running ohter sub...
try this idea Sub gobacktocell() Dim myadd As String mysht = ActiveSheet.Name myrng = ActiveCell.Address Application.Goto Sheets("sheet4").Range("a1") MsgBox "hi" Application.Goto Sheets(mysht).Range(myrng) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "SpeeD" wrote in message ... Hi. I need to determine the activecell at some point and move to it after other sub as run. how can i do this? i´ve tried the following without success... r = ActiveCell.Row c = ActiveCell.Column Run "Formatar_fundo_original" Range(c & r).Select Thanks SpeeD |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine activecell and move to it after running ohter sub...
Thnsks Nigel!
Works great! SpeeD "Nigel" wrote: Try using Cells(r,c).Select -- Regards, Nigel "SpeeD" wrote in message ... Hi. I need to determine the activecell at some point and move to it after other sub as run. how can i do this? i´ve tried the following without success... r = ActiveCell.Row c = ActiveCell.Column Run "Formatar_fundo_original" Range(c & r).Select Thanks SpeeD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine if Excel is running in a browser window | Excel Programming | |||
Determine If An Application is Already Running | Excel Programming | |||
VB TAB doesn't move activecell?? | Excel Programming | |||
Move ActiveCell down 12 then add up 11 above.... | Excel Programming | |||
How to determine if instance of Excel is running | Excel Programming |