Recent content by BatFace

Thanks so much everyone - it's working really well!

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 Kevin it worked beautifully...I made a little change to suit what I needed and it's fine - so fast and simple. I have given you a star for taking the time to explain what each variable was referring too also - it makes it much easier to understand the code for a wee novice such as...

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 Loomah, I changed it to the below code which is working (so far)...and changed my loop around - much better... Sheets("Sheet2").Select With Sheets("Sheet2").Range("a:a") Set c = .FIND(strFindText, LookIn:=xlValues) If Not c...

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...

Thanks Geoff - I'll try that when I get back to work..Public Holiday here today [bigsmile]...I actually have j-walkenbach's &quot;power programming with vba&quot; book - which is my other source of learning - glad u noticed 'cos I said I was a newbie and then felt like a cheat putting all that...

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...

Thanks Geoff if I wasn't a newbie to vba I'd be [blush] - at least I can hide behind that excuse! Why didn't I think of that? [bigsmile]

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...

YAAAAAYYYY This works! Thanks so much LSTAN, I knew it would end up being something simple [blush]

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...