AND formula does not work inside the macro module

Dear all, If I try to run below macro code inside the macro module then it does not work & showing

Please Login or Register  to view this content.

Run-time error '1004'
Application-defined or object-defined error

but it works very well in the excel sheet if i use direct formula (manual)

Hi nur2544,

Is the code you've posted the entire code?

The error '1004' usually means you haven't 'told' VBA about the objects you are using.

You need to start a VBA sub routine by writing something like the below;

Please Login or Register  to view this content.

Please advise if this is the entire code you are pasting into the VBA IDE.

Thanks

Hi

The below code will work until the row where I've added a comment about the unrecognised Function.

The main error was that you created a variable called 'LastRow' but you hadn't declared it in the code so the compiler doesn't know what it is.

What exactly do you want to do here?

Please Login or Register  to view this content.