I now have a problem when writing even a simple Macro eg
I get Compilation ErrorSub Unit2()
'
' Unit2 Macro
'
'
Sheets("Units").Select
range("A1").Select
End Sub
Wrong number of arguments or Invalid Property Assignment
It appears to only happen in one workbook, as the same macro takes me to Cell A! in a sheet called "Units"
Can anyone make some suggestions as I have nearly finished the whole workbook, and this is stuffing me up.
Last edited by Pbraun1; 02-01-2012 at 04:24 AM. Reason: No Tags
Hi Pbraun1
Unfortunately,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Please PM when you have done this and I will delete this post
If you have any problems let me know and I can help add them.
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks