Search results

Wow, just want to say thank you guys so much for this blog. Amazing that this post on an ODBC connection was able to help me with my vba code that has absolutely NOTHING to do with ODBC. I knew there must be a way to write to a network drive WITHOUT using the drive letter, but could not get it...

Here is what I ended up using. I could NOT get the vba format to work as I expected. An awful lot of trouble just to get this: August 25, 2012 - August 31, 2012 vs August 27, 2011 - September 02. 2011 Code: thisweek = Right(Range("a13"), 10) thisweekty = thisweek thisweekly = thisweekty...

Thank you Sir, for the speedy reply. Unfortunately, I cannot access dropbox from work but I will try this as soon as I get home this evening. Without seeing the file/code, I'm not following you very well, but I trust it will be clear when I can get the file. The "mmmm dd, yyyy" works for me...

I have tried every format I can think of to get "August 24, 2012" and I cannot. What am I doing wrong???? Code: Sub formatthedate() Dim thisweek As Date Dim lngDateFormatType As Long lngDateFormatType = Application.International(xlDateOrder) 'Order of date elements: '0 = month-day-year...

Gees, you don't miss a thing! You are of course correct. I typed it in rather than pasting and I missed the A2! Again, thanks so much. It is so nice to be able to get context specific, INTELLIGENT, timely help. This site is a lifesaver. Have a great weekend.

=SUMPRODUCT((ISNUMBER(FIND(B10,(A1:K1),1)))*A6:K6) This seems to be working for all conditions! I do have to use a space with the A, O, or Ms but I can live with that. Awesome!

I see how that works, but that defeats the purpose of my lookup cell. I would have to change my sumproduct formula every time I change the input. When I want to look up "weekly", I have to change the sumproduct to ....right(a1:k1,6). Same for Monthly, etc. I can certainly do that, but it...

I am trying to sum the table below based on the column headers. I want an input cell, "condition to sum", so I can enter a partial header and then sum accordingly. Example, sum all columns CONTAINING "A", or all columns CONTAINING "Weekly", etc. The sumif works for only the first line of the...

Just those from MicroStrategy, but there's two graphs per sheet. Thanks to Chandoo site, I think I can write the code, if I can figure out how to select/copy the graph images. Have never written anything for selecting/copying images. Then just paste special as jpg, and put in a loop. Will...

That is progress. It works. Next problem is that I export graphs to 100+ sheets at a time. I'm wondering if there's a better way than selecting/pasting each graph on each sheet, one at a time? if that's what I have to do, I have to do it. I just keep thinking there's something I can fix in...

I export directly from MicroStrategy into Excel. I add some grid data, comments, etc., then save the file.

I import graphs from MicroStrategy into Excel 2010, then save the files. The graphs are only visible on MY pc. Every other user gets this: X - The linked image cannot be displayed. The file may have been moved. . . bla, bla, bla. It is 'linking' the image to a temp file on my hard drive...

It looks like that will be just about perfect. Thanks so very much!

I feel like I'm overlooking something obvious, but I have searched Help, and Chandoo and can't find the answer! I have a workbook with multiple sheets that is used to receive imported data. The data is manipulated, then a printout is done. Then the file SHOULD BE closed without saving, to be...

WooHoo! That did the trick. Many Thanks!

Ok, I was good until SirJB7. I'm not sure I follow that. So, what I need is to change the .offset(0,-2).value TO .offset(0,-11) as below? With ActiveCell.Offset(0, 9) .FormulaR1C1 = .Offset(0, -11).Value .Font.Name = "Calibri" .Font.Size = 11 .Font.Bold = True .HorizontalAlignment =...

ActiveCell.Offset(0, 9).FormulaR1C1 = ActiveCell.Offset(0, -2).Value ActiveCell.Offset(0, 9).Font.Name = "Calibri" ActiveCell.Offset(0, 9).Font.Size = 11 ActiveCell.Offset(0, 9).Font.Bold = True ActiveCell.Offset(0, 9).HorizontalAlignment = xlCenter I have several sections of code similar...

Here's what I'm entering in my Select Data Source, Chart Data Range dialog box: ='Subtotals Paste Here'!District1 District1 is a named range that I adjust manually as needed. XL appears to accept it, but then when I go back to the chart, it has changed to this: ='Subtotals Paste...

Excellent. It never occurred to me to use sheets.name instead of the ridiculous but practical formula that I use within the worksheet. If you would care to elaborate on the ReDim statement, I would be very interested. If not, I'm just tickled to have an efficient answer. Thanks so much. Deb

Ok, have a workaround that actually works, but would really like to get it right. This gets the job done, but. . . Range("x2").Formula = "=RIGHT(CELL(""filename"",R1C1),LEN(CELL(""filename"",R1C1))-FIND(""]"",CELL(""filename"",R1C1)))" tabnames(ai) = Range("x2").Value It's using a 1000...

I want to create a very basic table of contents sheet at the beginning of my workbook. Count the sheets, loop thru each sheet recording the tab name in an array. Go to the TOC sheet and write that tab names in column A. That's all; very simple. NOT. I'm sure there's a better way to write...

Hot Diggity! That's EXACTLY what I wanted. As usual, I was making it harder than it really was. Columns D, E, F I only added for this illustration. Thanks again, SO much for your help! I will make an effort to use countifs as often as possible to get better.

Ok, I'm trying to process all the helpful comments. It sounds like countifs is not the best way to do what I'm doing. I have been able to get what I need using 'helper' columns, for this instance, but would like a better way in case I need to do it again. Also, I want to get it straight in...

I thought I was grasping the countifs, but apparently not. Maybe I'm just missing something really obvious. Why is the following countifs not giving me a 1 on the first line? I couldn't get anything to copy/paste here so please excuse the poor example...

I think my problem is similar. I have 8 graphs on separate tabs referring to (what I would like to be the named ranges) ranges on a Subtotal tab. These ranges do change from time to time; I adjust them manually and that is fine. My problem is that the graphs refuse to keep the reference as...