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:
  1. currSheetName = ActiveWorkbook.Worksheets(I).Name       'Get current worksheet name (this is fine & works)
  2.  
  3. 'Output Results Here:  Get the ERROR here
  4. ActiveWorkbook.Worksheets(I).cell(100, 1).Value = currSheetName

What am I doing wrong? Thanks,