ExcelBanter - blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - blank cells (https://www.excelbanter.com/excel-programming/314951-blank-cells.html)

James[_29_]

blank cells

How can I use xlCellTypeBlanks on rows rather than columns?

Ron de Bruin

blank cells

Use this James

On Error Resume Next
Rows("1:1").Cells.SpecialCells(xlCellTypeBlanks).. ....................
On Error GoTo 0

--
Regards Ron de Bruin
http://www.rondebruin.nl

"James" wrote in message oups.com...
How can I use xlCellTypeBlanks on rows rather than columns?

All times are GMT +1. The time now is 07:12 AM.