macro to run go to

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Columns("F:F").Select
Range("F11").Activate
Selection.SpecialCells(xlCellTypeFormulas, 1).Select
 
Do you have merged cells in column F that include cells from column E?

Merged cells can cause lots of pain.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Pasting cell contents into a macro 1
code breaks in macro 1
Better Understanding 4
Insert cells 1
macro recording 3
Automatically create names from values in cell 2
Automatically go to a cell when opening sheet 1

Back
Top