ExcelBanter - Deleting Rows

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

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

- - Deleting Rows (https://www.excelbanter.com/excel-programming/283813-deleting-rows.html)

Todd Huttenstine\(Remote\)

Deleting Rows

Cell K1 contains a number. That number is the cell I want to delete. What
is the code for this?

Chip Pearson[_2_]

Deleting Rows

Todd,

I'm not entirely clear on your question, but I think you want
something like

Rows(Range("K1")).Delete

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Todd Huttenstine(Remote)" wrote
in message ...
Cell K1 contains a number. That number is the cell I want to
delete. What
is the code for this?

Todd Huttenstine\(Remote\)

Deleting Rows

yes thats it thanx
"Chip Pearson" wrote in message
...
Todd,

I'm not entirely clear on your question, but I think you want
something like

Rows(Range("K1")).Delete

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Todd Huttenstine(Remote)" wrote
in message ...
Cell K1 contains a number. That number is the cell I want to
delete. What
is the code for this?

All times are GMT +1. The time now is 06:28 PM.