Quote:
Originally Posted by Logit
.
I don't have an answer for FREEZE PANES. Sorry.
|
I found it out, just to share just remove de .VisibleRange in the code at .left and .width also in the ".with =" replace the text to the value 100000 if you want to get a large size for the row selection instead of the size it shows with the code.
Quote:
Originally Posted by Logit
.
Regarding the fill handle. Highlight a row by clicking in a cell. The row is now highlighted and you should see the fill handle in the cell you clicked on. Grab the fill handle and drag the green outline to another row. Now click on the cell you wish to use the fill handle by clicking once in that cell. You will find that the green highlight does not follow in this scenario.
|
- Yes, thanks, that was what I said previously with "
... there is a workaround by selecting the "green" line, moving it to the side and going back to the cell to click on the handle (+). "
Quote:
Originally Posted by Logit
I can't take credit for the code as it is something I picked up somewhere but don't recall where.
|
- I see, thanks anyway for sharing what you found. I think I found it later and it was
here by Philip.
If I find something regarding the "green" line as background, I'll share here too.
All the best to all.
04-29-2018, 02:47 PM
Similar Threads
highlight the entire row of current cell
Windows 7 64bit 
Office 2010 64bit
Threaded Mode