View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tayseer.abdelhalim@gmail.com is offline
external usenet poster
 
Posts: 6
Default Starting a Macro where the cursor is

On Nov 3, 6:34 am, JLGWhiz wrote:
Hi Tayseer, after reading your post again, I think using the Selection.[do
something] approach would work. Disregard my suggestions about the
Workbook_Open and Worksheet_Change events. I had read your post as needing
something to trigger the macro instead of designating the starting point.
However, it is advisable to minimize the use of the Selection method as much
a possible. The code runs more efficiently if you use code that gives direct
instruction like
Sheet(1).Range("B5").[do something]



" wrote:
I recorded a macro to chart a range of data. But since the data can be
at any cell in the worksheet, I would like to generalize the macro by
telling it to start at the cell where the cursor happens to be.....I
would appreciate it if someone can tell me the code to do that


Tayseer- Hide quoted text -


- Show quoted text -


Thanx so much..I'll try it

Tayseer