Starting a Macro where the cursor is

[tayseer.abdelhalim]

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

 

[Guest]

You could use Selection.[do something] or ActiveCell.[do something]
but I would give it some serious thought before doing either. Maybe a
Workbook_Open event or a Worksheet_Change event would be a better approach.

 

[Guest]

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]

 

[tayseer.abdelhalim]

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]

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

 

[tayseer.abdelhalim]

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]

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 -

Sorry to bother you, but I am new to VBA. Here is the code that I
currently have:

Sub chart_test()
ActiveCell.CurrentRegion.Select
Set tbl = ActiveCell.CurrentRegion
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=tbl
End Sub

Thanx for all the help

Tayseer