Small macro need to modify

[nur2544]

Dear all , separately below macro runs very well

Please Login or Register  to view this content.

But if I add another macro together like below

Please Login or Register  to view this content.

Then I got error in the following line

Please Login or Register  to view this content.

Run-time error ‘1004’
Application-defined or object-defined error

[patel45]

Please Login or Register  to view this content.

if vcell is a cell in row 1 you can not have offset(-1)

[nur2544]

hi patel45, thanks for reply , would you please check the attachment, here from input sheet i need to results as output sheet.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[nur2544]

Hi JOHN,
Many Thanks , now it works..

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.