Highlight selected row or column in Excel VBA clrl+z = undo #excel #excelvba #msexcel #tepsavenn

=ROW()=CELL("row")
=COLUMN()=CELL("col")
Application.ScreenUpdating = True
you can use clrl+z = undo

**Apply_To_Multiple_Sheets
add-in file
Subscribe for more Video
Leave a Comment Thanks For Watching My Videos

[alseekski]

I've spent a day researching. All the other directions I looked at for highlighting the active cell deletes the undo history. This works. Not only that, it's a helluva simpler. Some of the other directions have tons of code. 1 bloody line of code. THANK

[kimsok]

This is amazing! I've spent I dont know how many days working on this. Thank you so much it works

[element]

This is actually the best and most simple method, compared to everything I've seen so far. The issue with the other methods are it takes longer to setup because of all the code involved and not only that! Those other methods won't allow you to use the undo feature in excel. Naturally, it's because macros cannot be undone. Macros are basically scripts that excel runs and that's it. You can't really undo a script, unless you coded it yourself and know how to implement it.

[mohammedal-mutairi]

Saved a lot of time to enter data correctly and precisely .. Thank you SO MUCH

[alseekski]

Seriously, you don't know how much this helped me. I have to take my computer outside and it's very hard to see. Plus it's easy to accidentally hit a key, so I need to be able to hit the undo button.

[SathiSupport]

Very useful video and short no time west only knowledge 🙂

[alaakhattab]

Thank you so much! Short, precise, and straight to the point 👌🏽

[fernandocamargo]

Perfect! Easy and straightfoward video!!!!

[mohamedrafiqumer]

this was a quick help specially the formulas we can copy written on your page
my question is how to keep the active cell in different color in this video

[si]

Thank god such a simple way of doing it, Had looked at so many other complicated ways. Tbh I don't know why they don't make this a option you can turn on and off within the programs itself. Thanks!

[controlhouseinternational]

Been looking for this! Very helpful! thanks a lot!

[jawandaworang]

Appreciated, you don't know how much this helped me. I have to take my computer outside and it's very hard to see. Plus it's easy to accidentally hit a key, so I need to be able to hit the undo button. #arDanishAbad

[saifremz]

This is actually the best and most simple method!! Kudos :)

[woajnabi]

Dear, you are great and made my work so easy.
Rather than apply this to single sheet, how it can be applied to all sheets at once.

[farrukhabbas]

Thanks a lot! best thing its short & effective..

[muhammadalmahy]

thank you very much!!
I have a problem when I select the active cell that is in a row with the merged row or column, my advice is to avoid the active column from the row or column that has been merged. otherwise the result is only a row of columns that work.

[kttan]

Thanks, it is simple and it works. So how can I apply that to the entire workbook please?

[BharatKumar-fhei]

After entering coding, it work properly & closed the file.
But again opening the same file pop-up display 'Not enough system resources to display completely' due to this can't open the file. Don't know why it shows, please guide me.

[ranjanc.]

This is great.!! Thank you.!! Can you show us if it highlights if we select multiple rows or columns please?

[shujatmunawar]

great, Thanks alot :)
I have a question
i did that and it worked fine, but not highlighting in the Google sheet ? Any idea ?