Search results for query: *

Not sure if this is used in 2000 but have you tried the Window - Unhide option to show Personal.xls and change the reference style there?

Thanks Smah, worked a treat. Sorry karmic, didn't get around to trying yours!

Can anyone help me with a way that 2 users on the same computer (using XP) can access the same inbox in Outlook Express for the same mail account? At the moment, whomever opens Express first receives all the email and the other user cannot see the new messages.

Hi haven104 The following macro will print all your sheets to column K using row 1 as the row to repeat at the top. Sub Printrange_All_Sheets() 'declares variables for counting rows, active sheet number and total sheets Dim sheetscount As Integer Dim sheetnumber As Integer Dim rw As Integer...

Spartain Sorry, I've never used the Function side of things with macros so I don't think I'll be much help. That being said I noticed a couple of errors in the codes [Code]If (Cells(row + 1, 1) = "") Then Cells(row + 1, 1) = fruit Cells(row +...

Try using a single quote ' before each item eg '213.230 rather than double quotes eg "213.230 or "213.230". Excel will show each item as a string but the quote will not be present when you open it.

Have you tried opening the database in 'exclusive' mode? (you do this by clicking on the drop arrow next to the Open button and selecting Open Exclusive) I realise that you are the only one with it open but Access sometimes likes to know that for sure.

Spartain First off try changing the ROW variable to RW as Row is a restricted name. Atylman

Hi Spartain Well it's not pretty but it does work. Hope your macro skills are up to adjusting this to suit your exact needs! This macro will need to be run after entering a batch of orders. Sub TekTip() ' ' TekTip Macro ' Macro written 23/06/2003 by Atylman ' 'Declares variables Dim rw As...

Hi Spartain I did reply & said that it would take some (simple) coding so I suggested that we move the assistance 'offline' and supplied an email address. Perhaps this is a no-no in this forum? Anyway, drop me a line at atylman@webone.com.au as this sort of thing needs some specifics to work...

Cheers Glen, worked like a charm!

Sorry, I didn't give enough info in the initial post. I believe it's the If statement that's going haywire ie. In the following code =IF(B1<&quot;31/7/1983&quot;,DATEDIF(B1,&quot;31/7/1983&quot;,&quot;d&quot;),&quot;Arrgh I'm going mad&quot;) if I have 30/7/1983 in B1 then it returns 1...

I get a #NUM error from my If statement when the logical test is False (or true if I swap the test) but it works fine when True. =IF(B1<&quot;3/7/1983&quot;,DATEDIF(B1,&quot;3/7/1983&quot;,&quot;d&quot;),&quot;Arrgh I'm going mad&quot;) Any ideas would be much appreciated as I am at wits end.