Run only if cell in column A is within range

[vonrainer]

Hello,

I've got a macro that works great. It posts the username and time in cell H and I if any values in that row are edited.
I now want to modify this code to post username and time on edits, only if the value in cell A is between 1000000 and 39999999

Here is the code i want to modify:

Please Login or Register  to view this content.

[majosum]

When you say "the value in cell A", do you mean the value in column A that is in the same row that you are posting the username and time? If so, then this should work below.

Please Login or Register  to view this content.

[vonrainer]

Wow.. That worked like a charm!!!

What if I would like to automatically delete an entire row where the value in column A is not within the same range? (only from Row 4 and down)

[majosum]

I have never used the "Target" command before, so I can't guarantee that the below delete command will work, but this is how you would set it up.

Please Login or Register  to view this content.

[vonrainer]

Hi,

Worth a shot, but it did not work. I might as well just create a new macro, and this is what I have tried (ended up with runtime error 424: object required):

Please Login or Register  to view this content.

Any suggestions on how to modify the code to work?

[vonrainer]

Ok, I've gotten a bit closer to what I want. The following code works, but it includes all cells in column A. How can I modify it to only run from cell A4 and down?

Please Login or Register  to view this content.

[majosum]

I have never been too good at event change macros. I think this requires a workbook_change event, but I can't get it to work.

If you manually run the macro when you make a change, I can help with that. Otherwise, I don't think I can be of any further assistance and I would suggest posting another thread asking for help with a change event.

[majosum]

Using the code you just added, try adding another IF statement

Please Login or Register  to view this content.

[vonrainer]

I plan on running this macro from a button, so workbook_change is not neccessary.

Se the post above (#6), where I have almost reached my goal. Just need the code modified to work from Row 4 and down

[majosum]

The additional statement in post #8 has an IF statement that checks to see if "i" (the row number) is greater than or equal to 4. See if that works.

[vonrainer]

You Sir, just made my day. It now works perfectly!

There is just one more addition to this macro I need (sorry I left that out earlier)
- How can I "hardcode" the macro to run on a different sheet?

The button for the macro will be on sheet named "Inbox", but the macro (deletion of rows) should occur in four different sheets
Think maybe some with-worksheets code are needed?

Run from sheet:
"Inbox"

Run in sheet:
"Norway"
"Romania"
"Aproval"
"Solved"

[majosum]

Do you want it to run in the "Norway" sheet, and then continue to the next three? Or you do you want to specify it to run in only one sheet at a time?

[vonrainer]

Well... Not sure if I understood your question, but will try to answer anyways. Perhaps the best would be if it first ran in "Norway", and when that is complete run in next sheet and so on and so on. (run in all sheets from one button)

[majosum]

Using your previous code, I added a select case to loop through and go to each worksheet automatically.

Please Login or Register  to view this content.

[vonrainer]

Thanks! Worked like a charm!