Hope this is okay to post here, thought someone might know what the problem is.
I'm writing a little VB macro in excel and I keep getting this error:
"Object doesn't support this property or method"
This is the first time I've written vb in excel so it's probably something really simple but my code seems okay:
2 Code:
currSheetName = ActiveWorkbook.Worksheets(I).Name 'Get current worksheet name (this is fine & works) 'Output Results Here: Get the ERROR here ActiveWorkbook.Worksheets(I).cell(100, 1).Value = currSheetName
What am I doing wrong? Thanks,




Reply With Quote