Excel 2007: Highlight Active Row

[galishan]

Sir, thank you so much



[supersonickaraoke]

great tutorial but 1 problem, after doing this my CTRL-Z (undo) function does not work???

[sethurk]

Your explanation is crystal clear buddy! I loved it!

[FloweyG]

This Macro is amazing BUT it doesn't work when I share the workbook.. would anyone know why??

Thanks in advance!!

[MrVisuallearning]

First step of highlighting row 1 did not work in 2007 ... odd!!!

Also how can you highlight row and column simultaneously? Thanks

[prakashwadhwani]

Super Video ... Thx a ton !! Very lucidly explained.

2 suggestions ... problems I faced

1) My file was originally an xls file ... Excel & forced me to save it as an xlsm file (macro enabled), else I'd have lost the typed VB code.

2) The "Developer" Tab was not visible to me initially.

Of course I'm extremely savvy with computers and it was a no-brainer to google & find it ... but it might prove disconcerting to a few users ... perhaps you could add it as a couple of lines somewhere ...

[FloweyG]

@prakashwadhwani hahaha gadha tu itna 'savvy' hota toh sab gogle aur youtube karne ki zaroorath nahi hoti

[Vapipelaya757]

Worked perfectly! The one dislike must not have known what "concatenate" meant lol.

[visamway]

Works perfectly, thank you very much.

I do not understand yet, how it works, but it is excellent, thank you again!

[minhthangub]

how do i cancel caculating all my fomular in my workbook after any click? (not using manual caculating)

[isaydivx]

Hi

This is just what I needed. I wanted something to Highlight the columns as well and modified it slightly and it worked fine. Also I only wanted the Headings or the Rows and Columns Highlighted and instead of choosing the entire worksheet, I just used the area I wanted Highlighted and it worked great. It's not yet perfect yet but this Video has helped a great deal.

[Mrjustacabron]

this is very good info. ....now here comes the question---is is possible to highlight only the active cell instead of the whole row??? if so, how can I do it?

thank you much

[paddle61]

Cool tip. Thanks.

Can I ask what programme you used to make the video? I'm looking for one that will give a visual representation when the mouse is clicked.

[6642633]

Thanks for the tutorial It comes in handy

now what if i want 2 highlight both the Row & Column of the activecell...

[Mardevac]

Thank you for the tutorial!! It comes in handy; however, how can I save it for use in different workbooks? I'd like to apply it to any new workbook, without having to re-do the macro.

[esmith0123]

Hi! This is a great tip!

The first day I wrote all the code and it worked like a charm. However, when I returned the next day to work- something went haywire and the code no longer works. I tried what I could think of (deleting the code/CF, resaving as a new file, starting over; making a new "name" and doing it that way with new code references) to fix it, but to no avail. Any ideas on what could be going wrong?

[esmith0123]

Hi- This is a great video/tip!

The first day that I tried it- I entered all the coding just as directed and it was working like a charm. Then, I quit for the day and returned the next- everything seems to be broken.

I tried using a new "defined name" and redid the whole thing, but to no avail.

I also tried saving as a new program while deleting all the code and then starting over- and nothing seems to bring back the great functionality!

Any ideas on what could be going wrong?

[HeyDoc]

Hi there Robert. Tks for the tip. I've implemented the macro and it looked like it was working just fine. However, after using the worksheet a little more, I noticed I was no longer able to run the undo command. I've double-checked the programming and it looks like it's just like yours. Any ideas?

[Bho8175]

Excellent tutorial! Can you provide additional VBA code for highlighting the column of the active cell as well (I'm assuming the CF is similar)?

Thanks

[wellfleetwine]

One problem I'm running into is that when the Macro is on, I lose my undo as soon as I jump from one cell to the next.

Otherwise the technique works great.

[firatyuksek]

really thank you man ,

works like a charm

you saved me a great time :)

with respect & Regards

[chrisjh805]

great work

but this is an utterly ridiculous amount of work to accomplish what should be a built in feature to a piece of software made by a software giant. microsoft excel FAIL

[adgurl01]

This was great! Just what I needed to get my work done more efficiently and accurately! Thanks!

[lispy3]

Could anyone write down the formulas please I can't read them on my iPhone the quality isn't clear enough! Many thanks

[IM2HARD2RESIST]

Private Sub Worksheet_SelectionChange( _

ByVal Target As Range)

With ThisWorkbook.Names("Activerow"­)

.Name = "Activerow"

.RefersToR1C1 = "=" & ActiveCell.Row

End With

End Sub

[cmart02]

CF is an easier route. But, yes, you could use VBA only.

[takingcookies1]

Would it work just using VBA ?

myRow = range(Activecell.row)

colorindex(myRow)

Just wondering why you had to use the conditional formating. Thanks!

[misaejung]

thank you so much

[WejOfOst]

Brilliant idea! I have been looking for the option to highlight the row I am working on for about 4 years.  BUT it does not work for me as it results in an complie error. I have done it on two different PCs and versions of Excel, checked very carefully and have word based detailed copies/screenshots of the results. How can I send these to you for that extra bit of help.

[cmart02]

You can send me the workbook where you created it and I will check it out for you.

[bau03123]

Hey. This looks like it could be very useful for a chemical list that I'm setting up. I tend to struggle with most things computer based but I managed to follow your tutorial up until you mention concatenation. How did you produce the concatenation symbol in visual basic?

cheers.

[cmart02]

It is the ampersand symbol (&). That's all there is to it.

[planiolro]

Awesome tutorial. I do not how to use VBA , but I manage to make it work for a sheet. I am interested to see this trick working for a workbook. You mentioned something in the clip, but I must say that I am a little bit confused about what do I have to do for this purpose! Maybe you can help me.

[cmart02]

Update was posted with query. I had to split into two videos though.

[liquidkernel]

Great! Thank you!

[AaronofKent]

Hi there. I have two identical sheets, one containing old data, and one containing revised parts. I'd like to add some conditional formatting to have a thin red border around any cells whose contents are not the same between the two sheets. Think you could make a tutorial for that?

[AaronofKent]

Wow. Great tutorial, very handy little script. I was straining my eyes trying to look across 8 columns of data, this definitely helps.

Thanks!

[cmart02]

Thank you for the comments. Whenever you need help, post what you'd like to see. Time permiting, I will be glad to post videos.

All the best

Robert