Hello. I trying to write a vbscript and I don't now why it doesn't work
I try to select data from C11 to E__ (last cell used in column E). I write a function:
Function GetPersonalData(objSheet)
With objSheet
last = .Cells(.Rows.Count, 5).End(xlUp).Row 'this doesn't work
Set GetPersonalData = .Range(.Cells(11,3), .Cells(last,5))
End With
End Function
When i write for example last = 23 everything work. I think that I make dump mistake :P
Can you help me? I write script in vbs filetype
Bookmarks