Posted to microsoft.public.excel.programming

CarlJ

external usenet poster

Posts: 5

Delete row depending on size of Characters in cell

Thank you Sharad
you really helped me
Carl

"Sharad" wrote:

Sub delRows()
For Each c In Worksheets("Sheet1").UsedRange.Cells
If Len(c.Value) 10 Then
c.EntireRow.Delete
End If
Next c
End Sub

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Limiting cell size to 25 characters	pj	Excel Discussion (Misc queries)	2	October 3rd 07 02:03 PM
Delete first two characters in a cell...	ChuckF	Excel Worksheet Functions	6	September 5th 06 08:46 PM
Delete first few cell characters	mohd21uk via OfficeKB.com	Excel Discussion (Misc queries)	4	June 7th 06 12:32 PM
delete all the cell that contains more than 25 characters	[email protected]	Excel Discussion (Misc queries)	2	June 7th 06 12:06 PM
Delete characters in cell	AuthorizedUserPF[_2_]	Excel Programming	3	July 14th 03 04:41 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us