Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent range reference
Hi,
I'm using below code in regular excel (not vba). When I run my macro the cell reference jumps automatically to the adjacent column (H becomes I and G becomes H). Is there any way to prevent this?! Either by code or by options?! =SUMPRODUCT(('Source Data'!$H$1:$H$5000=A96)*('Source Data'!$G$1:$G$5000=$B$94)) Regards, Basta |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent List Box Reference from Changing when workbook closes? | Excel Discussion (Misc queries) | |||
Prevent cut and paste over a range | Excel Worksheet Functions | |||
Prevent formula reference from changing | Excel Discussion (Misc queries) | |||
Excel - how to prevent new office version from upgrading word object reference | Excel Programming | |||
prevent row insert in a range of rows | Excel Programming |