Type Mismatch!!!
Okay so I'm a little rusty on my Excel VBA skills and I can't figure
out why I'm getting a type mismatch error for the following line in my
code:
Dim CopyEventDateCell As Date
Dim MyRow as integer
MyRow = 2
CopyEventDateCell = Workbooks("IT Operations Summarized Change
Report TEST.xls").Worksheets("IT Operations").Cells(MyRow, 6).Value
The only thing I can think of is it's an issue with the date format?
The cell value I'm referencing is in date format...I'm baffled, help!!!
Thanks,
Shelley
|