Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
in VBA Excel
Function GetText() As String Dim Str1 As String For Row = 51 To 74 Str1 = Str1 & Cells(Row, 3).Text Next Row GetText = Str1 End Function in worksheet cell C77 contains =gettext() Now when any row 51 to 74 and column 3 changes my function gettext does not update. Could some explain to me why and what I should do to fix it Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why won't th unhide function work?? | Excel Discussion (Misc queries) | |||
NETWORKDAYS Function doesn't work | Excel Worksheet Functions | |||
how do i get the mid function to work with a zero | Excel Worksheet Functions | |||
Which excel function would work best? | Excel Worksheet Functions | |||
Why doesn't my =RANDBETWEEN function work? | Excel Discussion (Misc queries) |