| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Activecell row number from another sheet
I'm sure I know how to do this but for some reason I'm blanking...
The program is currently working in SheetB. I want to return the row number for the ActiveCell in SheetA (without having to activate it). SheetA is in the same open workbook, is visible, is NOT protected. I then need to determine if the cell in column 5 for that row number on SheetA is blank. Can someone please help me out in remembering how to do this? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return the location (as a range) of ActiveCell? | Excel Discussion (Misc queries) | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Return number of current sheet | Excel Worksheet Functions | |||
| ActiveCell to top left cell of a sheet | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
