BrianMH
03-14-2013, 10:13 AM
I am trying to return a range with all the constants using specialcells.
For some reason it is returning all the cells with constants on the sheet instead of just the range I choose. It is doing this with
activecell.SpecialCells(xlCellTypeConstants)
and with
selection.SpecialCells(xlCellTypeConstants)
anyone have an idea as to why it isn't just returning the specialcells for what I want?
EDIT: figured it out. If you choose only one cell it does the entire sheet if you choose more than one it returns the correct result. Not sure why but at least I know.
For some reason it is returning all the cells with constants on the sheet instead of just the range I choose. It is doing this with
activecell.SpecialCells(xlCellTypeConstants)
and with
selection.SpecialCells(xlCellTypeConstants)
anyone have an idea as to why it isn't just returning the specialcells for what I want?
EDIT: figured it out. If you choose only one cell it does the entire sheet if you choose more than one it returns the correct result. Not sure why but at least I know.