VBA - copy cell value duplication issue

[Dream Ahead]

Hi everyone,

I have a bit of VBA code that is causing me a bit of a headache. Everything does what it should bar one little bit.

The code checks to see if column A in a particular sheet has a value. If it does, then it copies a corresponding value from a particular cell within another sheet.

The issue is the row highlighted in red. It seems to be an exception within itself. Whenever I run this code, it copies value B2, to column B in the other sheet around 30+ times than it is actually required. I've checked to make sure that cell A has no value, and it is completely blank.

Can anyone see how this should be rectified?

Please Login or Register  to view this content.

[xladept]

Hi Dream Ahead,

Do you want the B2 Value every time or should you recode that line:

Please Login or Register  to view this content.

[Dream Ahead]

Hi,

Yes I want it to constantly take the value of B2.

[xladept]

But just that value gets entered 30+ times more than it should?