Previous Topic Next Topic

Cell Value Comparison IF/THEN Situation

Closed
No Hair Left - 22 Jul 2010 à 12:15
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 Jul 2010 à 13:38
Hello,

I am tryong to write a macro that will compare the value in cell 1 (ACTIVE CELL) with the cell below (ACTIVE CELL OFFSET (0,1). If the amounts match, I want to delete the values in each cells. If the cell values do not match I want to leave them alone.

This loop can run for an arbitraty number of times...this I can handle, but the comparing I am not yet understanding.

Signed,
Struggling Beginner At VBA


1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 Jul 2010 à 13:38
What do you mean by Active cell. Did you mean active cell or did you meant that If cell value matches the cell value below it, then clear out values of both cells. In this case what if

A1: 12
A2: 12
A3: 12

Now since A1 value matches A2, we remove A1 and A2 value. What abuot A3

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response