Search results for query: *

Hi Everyone, I don't see outlook with vba info here often, but I'm hoping someone might be able to point me in the general direction...I've never used VBA with outlook before, so at the moment I'm not even sure this is possible. I need to generate a report from outlook (2000) that shows what...

Thanks in advance for any help you can give me! I am trying to do a loop which will look at the date entry in one cell then enter a string into another according to the value (eg if a1 is between 1/7/03 and 31/7/03 then d1 = "July NY")...The code I am using (it's messy I know but I am...

Thanks again for your help! I am using the following code to copy data according to autofilter criteria - this works fine, until there is no data marked as &quot;sold&quot; - it then copies the whole sheet...what code would I use to exit sub if criteria is <> &quot;Sold&quot...

And another problem.... Excel 2000 I am using the below code to find and mark data over 2 pages - the 2nd page (&quot;Sheet2&quot;) won't necessarily have data on it though...so I am getting an error message because the data can't be found on sheet2...the On Error Goto Nextstep works fine to...

Thanks again for your help! I am using the following code to copy data according to autofilter criteria - this works fine, until there is no data marked as &quot;sold&quot; - it then copies the whole sheet...what code would I use to exit sub if criteria is <> &quot;Sold&quot...

After the obvious answer to my previous question regarding filtering by set parameters I have put 2 listboxes on my user form....Because I'm a newbie to VBA playing with pivot tables was a wee bit daunting!...Here's the code I have: Dim AllCells As Range, Cell As Range Dim NoDupes As New...

I have the following code which is used to filter data according to 2 parameters entered by users in a userform...my problem comes when a usecode is entered that doesn't exist - users won't previously know which use codes are in the current month data. Because the usecode is not in this data...

I have the following code to find whatever is entered into the input box - move 11 columns right and enter &quot;Y&quot; in this cell; Dim strFindText As String strFindText = InputBox(&quot;type a number&quot;) If strFindText <> &quot;&quot; Then Range(&quot;p1&quot;).Value = strFindText...

I have the following code to find whatever is entered into the input box - move 11 columns right and enter &quot;Y&quot; in this cell; Dim strFindText As String strFindText = InputBox(&quot;type a number&quot;) If strFindText <> &quot;&quot; Then Range(&quot;p1&quot;).Value = strFindText...

Thanks in advance to anyone who can help me (again). This time I'm after code to send an email - from excel. I managed to get the message box to appear, with the file attached with - Application.Dialogs(xlDialogSendMail).Show then I added the below code (which I found here using keyword...

Thank You in advance to anyone who can help with this one. Excel 2000 - vba I have a spreadsheet which has imported data, updated monthly - the number of rows are variable. Column A is pre-sorted into id numbers and I am after code which will select all rows which start with a certain id...

Hi Gurus, I am working on a spreadsheet which has data for each day of the week, and I want to average this by the number of days that has passed (skipping any zero's). I have tried =sum(range)/countif(range<>,&quot;0&quot;) and {=average(if(range<>0,range))}, but these formula's won't work...