Posted to microsoft.public.excel.programming

external usenet poster

Posts: 8

explanation

Can someone please tell me what this function does. Especially the
"Cells(mycell.Row,4).value = ""

Secondly, what is the association between (mycell.Row, 4) and
Range(N6:N31)

For Each mycell In Range("N6:N31")
'' If mycell.Value n Then
'' Cells(mycell.Row, 4).Value = ""
'' Cells(mycell.Row, 5).Value = ""
'' End If

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
Would like an explanation of a formula:	Leo	New Users to Excel	4	November 9th 07 03:52 PM
Explanation please	Mekinnik	Excel Programming	2	October 31st 07 03:10 PM
FORMULA EXPLANATION	SSJ	New Users to Excel	7	July 26th 07 07:03 PM
Need an explanation	JLGWhiz	Excel Programming	2	June 15th 07 08:13 PM
Explanation of when & how to use ( ) { } : ; , ! etc?	Paul (Sydney Australia)	New Users to Excel	4	May 2nd 07 01:54 AM

All times are GMT +1. The time now is 11:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us