Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 5.0 release C update Terry B Excel Discussion (Misc queries) 10 August 31st 06 05:38 PM
Are you an Excel pre release 12 user?? gord Excel Discussion (Misc queries) 5 July 30th 06 03:56 PM
Excel 12 New Release Bart Vwb Excel Discussion (Misc queries) 5 October 4th 05 10:07 PM
.NET application does not release Excel Cameron Eckman Excel Programming 4 February 25th 04 11:50 PM
How to release the EXCEL.EXE procedure? Serge[_2_] Excel Programming 0 September 23rd 03 05:12 PM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"