macro to run go to
 

i have recorded a macro to select cells in a column that contain values from
formulas using "go to", when i recorded the macro this worked fine and all
the cells in the selected column with numbers in them were selected. however
when i run the macro it selects cells from the column to the left of it as
well?

is there a way of adjusting the code to stop this?


regards

patrick

macro to run go to
 

Post the code


"Patrick Bateman" wrote:

i have recorded a macro to select cells in a column that contain values from
formulas using "go to", when i recorded the macro this worked fine and all
the cells in the selected column with numbers in them were selected. however
when i run the macro it selects cells from the column to the left of it as
well?

is there a way of adjusting the code to stop this?


regards

patrick

macro to run go to
 

Columns("F:F").Select
Range("F11").Activate
Selection.SpecialCells(xlCellTypeFormulas, 1).Select

"Mike H" wrote:

Post the code


"Patrick Bateman" wrote:

i have recorded a macro to select cells in a column that contain values from
formulas using "go to", when i recorded the macro this worked fine and all
the cells in the selected column with numbers in them were selected. however
when i run the macro it selects cells from the column to the left of it as
well?

is there a way of adjusting the code to stop this?


regards

patrick

macro to run go to
 

Do you have merged cells in column F that include cells from column E?

Merged cells can cause lots of pain.

Patrick Bateman wrote:

Columns("F:F").Select
Range("F11").Activate
Selection.SpecialCells(xlCellTypeFormulas, 1).Select

"Mike H" wrote:

Post the code


"Patrick Bateman" wrote:

i have recorded a macro to select cells in a column that contain values from
formulas using "go to", when i recorded the macro this worked fine and all
the cells in the selected column with numbers in them were selected. however
when i run the macro it selects cells from the column to the left of it as
well?

is there a way of adjusting the code to stop this?


regards

patrick


--

Dave Peterson