Recent content by jdmaybee

Wow! Does that ever work!! As an old Lotus user I could literally write a macro by copying all the key strokes I used and bingo I had a macro. I had the (what turns out to be very unrealistic) idea I could figure out how to do this on my own! Just out of curiosity do you know how to name a...

It's a bit more difficult than that - that's why I named the two ranges I want to use to define the area - one day it will be A240 to M820 - the next it will A320 to M900. I want to be able to define a print range using the Topleft and Bottomright range names.

Thanks! That helped - it's amazing how something simple like that is so hard to find in all the VBA manuals I have...

I use Excel to import a recievables report from another piece of software. As you can appreciate it is not the same each time I import it. I have written a macro that does everything I want it to except define a range using a range name I define as Topleft (for say, cell A240) and Bottomright...

I wrote phenomenal macros in Lotus 1-2-3 and yet I find the simplest things almost impossible to find in all my VBA manuals. I am constantly importing a file from another package - before it's any good to me I have to remove copius rows of blank cells and sort the result so I can manipulate...

Thank you I get it now.

I decided to see how the other autofill techniques worked and ran the following: Sub FormatFill() ' ' FormatFill Macro ' Macro recorded 6/29/2011 by John D. Maybee ' Range("E1").Select Selection.AutoFill Destination:=Range("E5:E15"), Type:=xlFillFormats End Sub The first time it...

Thank you so much! I joined your forum from home so can't get you at work so I spent the whole day trying to understand how this works and in five minutes with your help I'm on my way!! Can I have two user accounts for the forum?

As an old Lotus user much of my thinking is based on the way it worked. I have used Excel for some time now and know about the little black square I can use to drag a progression of numbers down to whatever I like, but how do I write the proceedure in a macro?

I don't get this I tried Hui's solution =SUMPRODUCT(1*(MONTH(A1:A20)=3)) again just a few minutes ago and it worked like a dream! What do you suppose is going on here??

I tried Hui's suggestion and for some reason got a Value error. I am mystified why because the logic looks flawless. If you have any idea why I would be heavily indebted to you. I am using Excel 2002 if that has anything to do with it. Luke's response =SUMPRODUCT(--(TEXT(A7:A180,"mmm")="Mar"))...

I have tried both of the following: =SUMPRODUCT((A7:A180>=DATE(yr,month, day))*(A7:A180<=DATE(yr,month, day))) =SUMPRODUCT(--(A7:A180>=DATE(yr,month, day))*(A7:A180<=DATE(yr,month, day))) The dates are Excel dates in this format: 01/05/11 to 03/05/11