VBA Set rng question

[AussieVic]

Hi,

I would like to restrict the below code to range("C10:P") rather than all cells, how can i do this?

Set Rng1 = ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas, 1)

 

[SydneyGeek]

Try...

Set Rng = Range("C10:P5000").SpecialCells(xlCellTypeFormulas,1)

or similar

Denis

 

[Weaver]

Which row in column P? Or do you need to derive the last row at runtime?

Set Rng1 = ActiveSheet.range("C10:P?").SpecialCells(xlCellTypeFormulas, 1)

 

[AussieVic]

Try...

Set Rng = Range("C10:P5000").SpecialCells(xlCellTypeFormulas,1)

or similar

Denis

Thanks