View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linking to specific cells in pivot table Linking to specific cells in pivot table is offline
external usenet poster
 
Posts: 64
Default Macro error on MS Excel 10 for Mac Release 1

Hi - a spreadsheet I created is giving an error when another person is
opening the file on their computer. Unfortunately I don't know what the
error says, but Im pretty sure that it has something to do with the version
of Excel they are using (using Mricrosoft Excel 10 for Mac Release 1).

Below is the code that I believe is triggering the error - was wondering if
the info I provided would be enough for someone to let me know how I can fix
this issue. Any help is appreciate!! Thx - Robert


Private Sub Workbook_Open()

Dim rng As Range

Set rng = Sheets("Proj.Mngt.").Range("I45").End(xlUp).Offset (1, 0)

rng.Value = Now()
rng.Offset(0, 1) = Application.UserName

End Sub