How to interpret the difference between the two lines of code.

[NARAYANK991]

Hi ,

I never expected so many errors in such simple code.

The End If and the End With are mixed up , as follows :

      End If
Beep
End With

They should be rearranged as follows :

      End With
Beep
End If

Narayan

 

[Chirag R Raval]

Dear sir @NARAYANK991 ,

I added "With Activesheet" and "End With" & run... its working ..


but its made only "Italic" .. & only on columns "C"'s data
not process entire row 5 and below...all rows

also not process on I added ".Colo=vbRed" ...that also not work


Regards,
Chirag Raval

 

[NARAYANK991]

Hi ,

Please upload your workbook , with data and code in it.

Narayan

 

[Chirag R Raval]

Dear Sir,

Attached as per your doing needful..

Regards,

Chirag Raval

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Chirag R Raval]

Dear Sir,

Many Thanks...
Its working...Perfect...As desired..

But how can we modify code , that its work on entire rows 5 & below
all rows from range of columns "A:L"...?

Regards,

Chirag Raval

 

[NARAYANK991]

Hi ,

Changing the line of code :

Set myrange = ActiveSheet.Range("A5", Cells(Rows.Count, 12).End(xlUp))

will change myrange to include all columns from A through L.

Narayan

 

[Chirag R Raval]

Dear Sir,

Thank you very much

My modified & your constructed both works fine...

(1)My Modified

Set myrange = ActiveSheet.Range("A5:L5", Cells(Rows.Count, 3).End(xlUp))

WORKING OKAY

(2) Your constructed

Set myrange = ActiveSheet.Range("A5", Cells(Rows.Count, 12).End(xlUp))

also work amazingly..

Many thanks to you all expert to help..

Regards,
Chirag Raval

 

[Eloise T]

Dear Sir,

Thank you very much

My modified & your constructed both works fine...

(1)My Modified

Set myrange = ActiveSheet.Range("A5:L5", Cells(Rows.Count, 3).End(xlUp))

WORKING OKAY

(2) Your constructed

Set myrange = ActiveSheet.Range("A5", Cells(Rows.Count, 12).End(xlUp))

also work amazingly..

Many thanks to you all expert to help..

Regards,
Chirag Raval

You can also set a Conditional Format:










DONE!

 

[Chirag R Raval]

Dear @EloiseT

Thank you very much for your valuable gude..
I wil try it in my dynamic code as per your attached files.

Definetly It will very helpful to all users who
In search for solutions for their this type of requirement.

I will reply soon after check.

Thanks again..

Regards,

Chirag Raval