| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Hybrid Mode
