c.row will give you the number you want
c.row will give you the number you want
Josie
if at first you don't succeed try doing it the way your wife told you to
I have made a bit little changes to the function and have used "c.row" but it is thowing some different error now.
![]()
Public Function displayExpectedValues() startRowValue = InputBox("Enter FirstRow Number to read data") EndRowValue = InputBox("Enter Last Row Number to read Data") c = Sheets("Result Reader").Range("Q" & CStr(startRowValue)) Do While startRowValue < EndRowValue c.Offset(0, 1) = getIZV(c.Row) ' Object Required error c.Offset(0, 3) = getIZV(c.Row) c.Offset(0, 2) = c.Offset(0, 1).Value + c.Offset(0, 3).Value startRowValue = startRowValue + 1 Loop End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks