I would like a macro that looks for the value "ERROR" in column AX and then display the values from column A one row above the row with the "ERROR" value in AX into one message box.
Can this be done, or is there a more efficient way of doing this?
Thank you
Last edited by pasqualebaldi; 01-28-2016 at 12:44 PM.
try this way:
Please Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
When I try to run this, I get "Run-time error '1004': Method 'Range' of Object'_Worksheet' failed"Originally Posted by bulina2k
try this way:
Please Login or Register to view this content.
To return multiple errors.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I.m sorry. I missed .row
For Each cel In Range("AX2:AX" & Cells(Rows.Count, "AX").End(xlUp).row)
Thank you! Can this be modified to display 1 row up like it is doing now, but instead displaying the value in column AX, can the message display the value in column A?
For example: AX10="ERROR" so the message box displays A9 value
Thanks!
I see where I needed to modify the offset. Thank you very much for all of your help. I really appreciate it!
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mehmetcik; 01-28-2016 at 02:09 PM. Reason: DeBugged
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks