Small macro need to modify

**nur2544** · 11-12-2013, 09:53 AM

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** · 11-12-2013, 09:59 AM

Please Login or Register  to view this content.

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

**nur2544** · 11-12-2013, 10:12 AM

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** · 11-12-2013, 11:02 AM

Maybe:

Please Login or Register  to view this content.

**nur2544** · 11-12-2013, 11:11 AM

Hi JOHN,
Many Thanks , now it works..

**JOHN H. DAVIS** · 11-12-2013, 11:16 AM

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

Re: Small macro need to modify