Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
strange range access
Set r = Union([a2], [a4], [a9]) r.FormulaR1C1 = "=r[-1]c" r.Value = r.Value i want to chang result value of function of non continuous cells to value.... *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
strange range access
Sub Tester()
Dim a As Range, r As Range Set r = Union([a2], [a4], [a9:b9]) For Each a In r.Areas a.Value = a.Offset(-1, 0).Value Next a End Sub Tim "tom taol" wrote in message ... Set r = Union([a2], [a4], [a9]) r.FormulaR1C1 = "=r[-1]c" r.Value = r.Value i want to chang result value of function of non continuous cells to value.... *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
strange range access
Using of for loop, no, no... I want to do once. express access *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange New Line text when importing from Access 97 | Links and Linking in Excel | |||
Help understanding truely strange error involving access query and filling cells | Excel Programming | |||
Strange VBA speed issue based on whether overwritten file originallyexisted or not (?I think?). Excel from Access VBA | Excel Programming | |||
Strange VBA speed issue based on whether overwritten file originally existed or not (?I think?). Excel from Access VBA | Excel Programming | |||
Strange or error : For each cl in Selection 'cl as range | Excel Programming |