Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't "Workbook.Range("myrange").value" work?
Thanks Matthew, I didn¹t realise that I needed the ³RefersToRange² part for
it ot work. Cheers, Bp.) in article , Matthew Connor at mcon__dontneedthis__nor1600@ya__dontneedthis__hoo. com wrote on 8/7/03 2:50 PM: Personally, I'd go with method 'B' and avoid the Activate command. To get method 'B' working, try using: tDataA1 = MyWB.Names("DataA1").RefersToRange.value (I just asked a similar question sometime last week - Francisco Mariscal helped me out then.) Hope this helps, Matthew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |