Problem with Range selection macro

[floridagunner]

Hello,

I am running the following piece of code in my macro.

Sub SelectData1()

Set mySelection = Range(ActiveCell, ActiveCell.End(xlDown))
mySelection.Select

End Sub

When I run the above code as a stand alone macro it always works as it should; ie. it selects all the data in the column below the active cell.

However when I'm running it as part of a larger macro instead of selecting the data below the activecell in column R it jumps to selecting all the data in column A.

Anybody have any ideas on how this can be fixed?

 

[wigi]

You do not need to select. For example, change this:

[LEFT][COLOR=#333333]myRange.Select
[/COLOR][COLOR=#333333]Selection.Font.Bold = True[/COLOR][/LEFT]

into:

[LEFT][COLOR=#333333]myRange.[/COLOR][COLOR=#333333]Font.Bold = True[/COLOR][/LEFT]

and observe that it works faster, better and with less code.

 

[Norie]

floridagunner

ActiveCell isn't what I would call 'unstable' but it is unpredictable when used in code that uses Active/Select.

It's much better to explicitly reference the ranges/worksheets/workbooks you want to work with.