| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying Current Cell
Hi
Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Try Chip Pearson's row liner:-
http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
It an add-in so:-
Tools|addins|browse navigate to where you saved it and click OK. If you ensure rowliner is checked in the addins box it will be there when you start up. With regard to highlighting the entire row/column then that would be a change to the code or you could try this pasted in as worksheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Mike "Stanley" wrote: Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Thanks, Mike. This is very useful. I copied and save it as .xla. I have added it in the adds-in box. But, when I open a new excel, this functionality is not available. How can I make this available for any Excel file opened ? Thanks. stanley "Mike H" wrote: It an add-in so:- Tools|addins|browse navigate to where you saved it and click OK. If you ensure rowliner is checked in the addins box it will be there when you start up. With regard to highlighting the entire row/column then that would be a change to the code or you could try this pasted in as worksheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Mike "Stanley" wrote: Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Stanley,
It already was a .xla file and if you have navigated to it from the addins box it should be available evry time you start Excel. If you are using it by running rowliner.xla (by double clicking it) then you are doing it incorrectly and it won't be available when you start Excel. Mike "Stanley" wrote: Thanks, Mike. This is very useful. I copied and save it as .xla. I have added it in the adds-in box. But, when I open a new excel, this functionality is not available. How can I make this available for any Excel file opened ? Thanks. stanley "Mike H" wrote: It an add-in so:- Tools|addins|browse navigate to where you saved it and click OK. If you ensure rowliner is checked in the addins box it will be there when you start up. With regard to highlighting the entire row/column then that would be a change to the code or you could try this pasted in as worksheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Mike "Stanley" wrote: Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Anyone know how to get round the following known issue with this add-in -
"RowLiner will not draw lines in split windows or frozen panes" ? -- David M WinXP - Office2003 (Italian) "Mike H" wrote: Stanley, It already was a .xla file and if you have navigated to it from the addins box it should be available evry time you start Excel. If you are using it by running rowliner.xla (by double clicking it) then you are doing it incorrectly and it won't be available when you start Excel. Mike "Stanley" wrote: Thanks, Mike. This is very useful. I copied and save it as .xla. I have added it in the adds-in box. But, when I open a new excel, this functionality is not available. How can I make this available for any Excel file opened ? Thanks. stanley "Mike H" wrote: It an add-in so:- Tools|addins|browse navigate to where you saved it and click OK. If you ensure rowliner is checked in the addins box it will be there when you start up. With regard to highlighting the entire row/column then that would be a change to the code or you could try this pasted in as worksheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Mike "Stanley" wrote: Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Chip Pearson notes this limitation on his website and if he hasn't fixed it
then it probably isn't going to get fixed. Mike "#DIV/0" wrote: Anyone know how to get round the following known issue with this add-in - "RowLiner will not draw lines in split windows or frozen panes" ? -- David M WinXP - Office2003 (Italian) "Mike H" wrote: Stanley, It already was a .xla file and if you have navigated to it from the addins box it should be available evry time you start Excel. If you are using it by running rowliner.xla (by double clicking it) then you are doing it incorrectly and it won't be available when you start Excel. Mike "Stanley" wrote: Thanks, Mike. This is very useful. I copied and save it as .xla. I have added it in the adds-in box. But, when I open a new excel, this functionality is not available. How can I make this available for any Excel file opened ? Thanks. stanley "Mike H" wrote: It an add-in so:- Tools|addins|browse navigate to where you saved it and click OK. If you ensure rowliner is checked in the addins box it will be there when you start up. With regard to highlighting the entire row/column then that would be a change to the code or you could try this pasted in as worksheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Mike "Stanley" wrote: Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Identifying Current Cell
Hi Mike
The situation is like this. I copy the program you have given, and store it. Yes, from Add-Ins, that option by default is already selected. I can verify from the Macro Visual Basic, it is there too. But, whenever I open a new excel file, it is not functioning. It looks like, it is available there, but it is not activated, kind of. Thanks. stanley "Mike H" wrote: Stanley, It already was a .xla file and if you have navigated to it from the addins box it should be available evry time you start Excel. If you are using it by running rowliner.xla (by double clicking it) then you are doing it incorrectly and it won't be available when you start Excel. Mike "Stanley" wrote: Thanks, Mike. This is very useful. I copied and save it as .xla. I have added it in the adds-in box. But, when I open a new excel, this functionality is not available. How can I make this available for any Excel file opened ? Thanks. stanley "Mike H" wrote: It an add-in so:- Tools|addins|browse navigate to where you saved it and click OK. If you ensure rowliner is checked in the addins box it will be there when you start up. With regard to highlighting the entire row/column then that would be a change to the code or you could try this pasted in as worksheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Mike "Stanley" wrote: Hi Mike, This is great.... but, few more questions: 1. Instead of having it by line, would it be possible to mark the row and column with colors banding instead? 2. I have downloaded this and use it. That is ok. But, after I close it, and re-open a new Excel, it is not there anymore. I have always to open this first. If in case, I download from ERP system an Excel output, then how can I ensure that, this is already built in there for me? Thanks. stanley "Mike H" wrote: Try Chip Pearson's row liner:- http://www.cpearson.com/excel/RowLiner.htm Mike "kaayyes" wrote: Hi Can someone help me to know how to locate the current active cell using color banding highlight the row and column (like a cross-wire) -- kaayyes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying first non blank cell in 3 different columns | Excel Discussion (Misc queries) | |||
| identifying the page a named cell is on | Excel Discussion (Misc queries) | |||
| How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
| Identifying a cell/value in a table | Excel Discussion (Misc queries) | |||
| identifying current month | Charts and Charting in Excel | |||
Linear Mode
