Search results

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

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

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

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

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

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

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

This is the end of a module where I am calling (attempting to call) three other modules to finish up. Everything works fine except the sort worksheets line. If I take it out all is good. When I add it, the code won't even run. I get the expected procedure not module error. It's a module...