One way:

x = lastincolumn(Sheets("Sheet1").Range("C:C"))

In article ,
"vrk1" wrote:

for instance when I say x = lastincolumn("Sheet1!c:c")

Excel throws an error msg saying Type Mismatch

How do I call this function within VBA and assign this to a variable