How to return the cursor back to original cell
Hello,
I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
First in macro:
org = ActiveCell.Address Last in Macro: Range(org).Select "Frank Situmorang" skrev: Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
It is not clear to me excellent, are y saying in the first row of the macro
we type: org = ActiveCell.Address and in the last row we type: Range(org).Select I appreciate if you could elaborate it again, Thanks, Frank "excelent" wrote: First in macro: org = ActiveCell.Address Last in Macro: Range(org).Select "Frank Situmorang" skrev: Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
ok Frank, maby i didnt get it right
try explain again "Frank Situmorang" skrev: It is not clear to me excellent, are y saying in the first row of the macro we type: org = ActiveCell.Address and in the last row we type: Range(org).Select I appreciate if you could elaborate it again, Thanks, Frank "excelent" wrote: First in macro: org = ActiveCell.Address Last in Macro: Range(org).Select "Frank Situmorang" skrev: Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
Ok here is my problem:
By the help of this forum I can create a kind of a databank of the actual price list taken from all puchase order lines. If Iwant to see a certain materials/good, I just type *valve* for example all material with word"valve wil be filtered. Since my worksheet has many colums while I am only interested in certain columns I make a macro at the top of the page. To look for for certain valve price list I put mu cursor on it, but some times I want to undhide the specs's column, then I click macro button at the top, but I want it back again to the original where I pointed the cell, otherwise to go back to that cell manually takes time. Can you tell me what vba should I make? Thanks in advance. Frank "excelent" wrote: ok Frank, maby i didnt get it right try explain again "Frank Situmorang" skrev: It is not clear to me excellent, are y saying in the first row of the macro we type: org = ActiveCell.Address and in the last row we type: Range(org).Select I appreciate if you could elaborate it again, Thanks, Frank "excelent" wrote: First in macro: org = ActiveCell.Address Last in Macro: Range(org).Select "Frank Situmorang" skrev: Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
org = ActiveCell.Address variable "org" is saving celladdress when u
actvate macro Range(org).Select is returning to celladdress savd in variable "org" so put theese 2 lines in the macro u start when the curser is in the cell u wana return to "Frank Situmorang" skrev: Ok here is my problem: By the help of this forum I can create a kind of a databank of the actual price list taken from all puchase order lines. If Iwant to see a certain materials/good, I just type *valve* for example all material with word"valve wil be filtered. Since my worksheet has many colums while I am only interested in certain columns I make a macro at the top of the page. To look for for certain valve price list I put mu cursor on it, but some times I want to undhide the specs's column, then I click macro button at the top, but I want it back again to the original where I pointed the cell, otherwise to go back to that cell manually takes time. Can you tell me what vba should I make? Thanks in advance. Frank "excelent" wrote: ok Frank, maby i didnt get it right try explain again "Frank Situmorang" skrev: It is not clear to me excellent, are y saying in the first row of the macro we type: org = ActiveCell.Address and in the last row we type: Range(org).Select I appreciate if you could elaborate it again, Thanks, Frank "excelent" wrote: First in macro: org = ActiveCell.Address Last in Macro: Range(org).Select "Frank Situmorang" skrev: Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
Thanks a lot excellent, it's wonderful..
Frank "excelent" wrote: org = ActiveCell.Address variable "org" is saving celladdress when u actvate macro Range(org).Select is returning to celladdress savd in variable "org" so put theese 2 lines in the macro u start when the curser is in the cell u wana return to "Frank Situmorang" skrev: Ok here is my problem: By the help of this forum I can create a kind of a databank of the actual price list taken from all puchase order lines. If Iwant to see a certain materials/good, I just type *valve* for example all material with word"valve wil be filtered. Since my worksheet has many colums while I am only interested in certain columns I make a macro at the top of the page. To look for for certain valve price list I put mu cursor on it, but some times I want to undhide the specs's column, then I click macro button at the top, but I want it back again to the original where I pointed the cell, otherwise to go back to that cell manually takes time. Can you tell me what vba should I make? Thanks in advance. Frank "excelent" wrote: ok Frank, maby i didnt get it right try explain again "Frank Situmorang" skrev: It is not clear to me excellent, are y saying in the first row of the macro we type: org = ActiveCell.Address and in the last row we type: Range(org).Select I appreciate if you could elaborate it again, Thanks, Frank "excelent" wrote: First in macro: org = ActiveCell.Address Last in Macro: Range(org).Select "Frank Situmorang" skrev: Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
How to return the cursor back to original cell
Try this that Joel sent to me a couple of days ago.
Dim strPlace as String Set strPlace = ActiveCell 'place at the beginning of Sub() strPlace.Select ' place when you want to go back like at the end of Sub() John "Frank Situmorang" wrote in message ... Hello, I have created a data bank using a kind of filter. At the top row I have a button of macro for hiding and unhiding columns. My question is what VBA should I put in order to put the cursor back automatically jump back to original cell. To be more clear, following the sample: Macro button a b c d e 1 2 3 4 original cursor here, after filtered I want the cursor back to original when pressing button, We appreciate for any idea. Thanks in advance Frank 2 2 |
All times are GMT +1. The time now is 12:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com