Vba code makes workboos slow. Any alternate code ??
Dear members,
I am using below event code to highlight current row (With Borders) from A column to R column . But if file have large data then this code make workbook slow. Is there any alternate code for same ?
Please Login or Register to view this content.
Any help may appreciated.
Thanks
Regards,
Nandkumar S.
---------------------------------------------------------------
Don't forget to Click on * if you like my solution.
Hi, I think it is better to use conditional formatting like:
=ROW(A1)=ROW(INDIRECT(CELL("address")))
apply it to the range you want it to work for with A1 active.
You need to recalculate when you change selection which you can do using:
in the worksheet object, this also has the advantage of still allowing use of the undo tool.Please Login or Register to view this content.
Dear sir,
Thanks for quick reply,
Please give me steps for conditional formatting as I am using office 2007.
Yes works nice
I have small problem. I there any way (I mean Formula) to highlight only A:R instead of entire row.
Last edited by satputenandkumar0; 04-22-2014 at 09:57 AM.
Hi - only apply the conditional format to columns A:R, not the entire worksheet.
Oh ! How stupid I am.....
Any way Thanks for helping.
rep added to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks