Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reference a precedent range in another sheet?
Given cell formula:
=ASheetOtherThanThisOne!A1 how do I reference that range in, say, the sheet's Change event? (This works: with Target n = Instr(.Formula, "!") Set R = Worksheets(Mid(.Formula, 2, n - 2)).Range(.Formula - n) end with But that's not programming. That's bull****. Surely VBA has something better?) *** Thanks as usual to those Knights of the Web who ceaselessly help us de- clued cats out. *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Reference When Copying Sheet fm One WB to | Excel Programming | |||
Trace Precedent | Excel Worksheet Functions | |||
reference range in other sheet | Excel Discussion (Misc queries) | |||
Given a range of cells, some of which contain errors (e.g. #DIV/0), replace each cell having an error with the value of a non-error precedent cell | Excel Programming | |||
precedent | Excel Discussion (Misc queries) |