Search results

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

Thanks!

I asked two questions yesterday and got repsonses to each of them. The first almost worked but I got a Name error when applying it and had written back to see why that happened. The other was how to format my numbers so the negatives showed in red as (1,000.00). Fortunately I printed out the...

Thanks again. Now I get a #Name? error message - what could be causing that? Am I doing something wrong?

Thank you! When I use that formula I am getting bracket erroro messages

If I have a column of dates is there any way I can find out how many of them were for a particular period/month without setting up another column that has the formula =MONTH(x1)to interpret the data? In other words "How many January 2009's are there in this list?"

I like the custom numeric format #,###.00_);[RED](#,###.00);0.00 Is there any way I can set this up on my toolbar like the , format?

Too easy!! Thanks

This may be a bit pedestrain, but why not set up your top line with a cell for each color you want to use and then use the paintbrush to paint the cell you want?

I have been trying to show a numeric total as mixed text and numeric like this: Balance $xxx,xxx.xx down to Balance $-xx,xxxx.xx The following formula works nicely for amounts over $10.00 but it always shows anything less than zero as Balance $-x,xxx.xx Does anyone know how I can get it to...