Run-time error 7 out of memory vba

This is my first post here and second day trying to use VBA to solve some problems/shortcuts in Excel (I'm learning by trial and error).
Using macros and help from this forum I was able to sort some code that I was happy with.
Problem is when I use second macro (that I found on the net-which is working in blank workbook) I get "Run-time error 7 out of memory"
in first macro which I am not using at the time.

The problem is in the third line "If Target.Column = 20 And Target.Value = "B" Then"

Please Login or Register  to view this content.

Thanks for help in advance.

Hi,

How big is the file?
Have you got any other applications or Excel workbooks open at the same time? If so close them all and see if that helps.
Is there only one version of Excel open?

Hi,

In the absence of the workbook we'll have to guess.

It may be that the action of code 2 is firing the code 1 macro many times. i.e. every time the many code 2 instructions change the Data sheet.
What happens if you start the code 2 macro with the instruction
Application.EnableEvents = False
and finish it with
Application.EnableEvents = True

Why are you using the Workbook Sheet Change event? Are you really wanting it to fire whenever anything is changed anywhere?
If you use it on a sheet other than the Data Sheet used by code 2, use the Worksheet Change event instead.

Part of your problem is that you are using a workbook.sheetchange event. So, when a change is made in any cell in any sheet the event is triggered. Your second macro is changing some sheet and, therefore calling the sheetchange event code. The sheetchange event code is making further changes and, thus calling itself: the changes are calling changes that are calling changes... until you run out of memory.
You need to turn off event handling while the code is modifying the sheets:

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.