Search results for query: *

I was having long delays deleting rows from, and when changing data in a large sheet that had mainly conditional lookups. (e.g. =IF(M135=1,S135/(VLOOKUP(Z135,swdctgt,4,0)),0) ). Everytime I changed one cell or deleted/inserted a row, it seemd to take 40 - 50 secs. In my case, the issue was...

OK so I can't change the "arrow" directly. [sad] Is there VBA code that I could use to change the color of the heading if it's a filtered col?

I have a major spreadsheet with over 60 cols of data. I have a freeze panes set at cell D3, and users scroll across, often filtering on 4 or more cols. They often zoom to 75%, and hide some cols to view more of what they want on the one screen. ISSUE : not easy to tell which cols have filters...

Chad, thanks for taking the time to look at this. Currently I only have a spreadsheet! There are around 3000 server/app combinations, and typically I manually drill down usually 3, sometimes 4 levels. I'd really like to build a hierarchical view. I thought I would need one table keyed by server...

My problem: I have a table with application ID's and the servers on which they reside, and an index for server to app. Both are many to many relationships. I need to drill down until I have all apps / servers involved or connected to one app or one server e.g. serverA has to be relocated...

Thanks, Sawedoff. I'm running 2003. The problem is that the option you suggested applies to all calendars, so when I turn off the reminders in the shared calendar, it also affects my regular calendar. I want the reminders to popup in my calendar (where all conf calls include me), but to...

Go into the VBA screen, and type "msgbox" into the search help.

Our group shares a conference call line. To avoid having to ask around to find out if it's being used at a specific time, I set up a Public Folder calendar, and added each group member as an author. Each of us then added a rule to our Outlook so that when we create a meeting using the conference...

Our group shares a conference call line. To avoid having to ask around to find out if it's being used at a specific time, I set up a Public Folder calendar, and added each group member as an author. Each of us then added a rule to our Outlook so that when we create a meeting, a copy is written...

I've had great answers in the past, so let's try this one: I have 4 sheets in a workbook, named A - D. I want to have 4 buttons, each with a macro that activates a specific sheet, and selects a specific cell. I know that my users can click on say, sheet A, but I want them to see a button on...

I have a VLOOKUP that pulls text into a "wrapped" text cell. I want to specify a gap between the last line of text and the bottom border of these cells ( to space things out) Horizontally I can use the indent, but is there a vertical equivalent?

I have a small DL and want to send emails FROM our group, not specifically from me. I selected "from" in the View menu, but when I add the DL, I get an error, even though I own the DL. How can any of us in the DL send emails FROM the DL? Thanks

I want to put today's date in cell E3 if the user has changed anything. I thought I could use Worksheet_Change, and I coded that as: Range("e3").Select ActiveCell.Value = Format(Now, "dd-mmm") This works, but then the active cell is E3, and the user obviously wants to be in the cell...

Ron - Thanks for the idea, but there's another condition: The manager may not want the updated timesheets - he may want what was there last time he opened it. So I have a msgbox that asks if you want to update the sheets. If I link, I think it will update every time it's opened. [ponder]

Do you have enough free space for your temp file (10Gb +) ? http://support.microsoft.com/kb/224029

Mmm I wish I'd thought of that before I started! It's only 4 people, so I'm not sure it's worth a rewrite. Thanks again for your help [smile]

I have timesheets with a Workbook_Open macro that asks if it's a new week. If it is, it adds 7 days to a cell and uses that as part of the file name for the save. Works fine, each member of the team has their own wkbk, and the date is the same in each. I copy those 3 into one workbook with a...

Thanks, guys! I now am able to copy the 3 time sheets into 1 summary wkbk. Can anyone help me with the second question? The open macro for each time sheet gets executed when the VBA in the summary wkbk is run. i.e. the summary VBA triggers the "new week?" msgbox in each timesheet it opens...

Hi, Skip, here's the code Private Sub Workbook_Open() a = MsgBox("Start a New Week?", vbYesNo) If a = vbYes Then Dim hammer As String Dim enextdate As Date Dim efiletxt As String Range("E3").Select ecurrdate = ActiveCell enextdate = DateAdd("d", 7...

I need help: 3 staff each update their own "timesheet", which has a Workbook_Open macro that asks if it's a new week. If it is, it adds 7 days to a cell and uses that as part of the file name for the save. Works fine, each member of the team has their own wkbk, and the date is the same in each...