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
|