Search results for query: *

You nailed it. It does work. I had created sample data in Excel that looked like good data, but there is something in it that crashes when run with the macro. Good job! Alex

I work with a number of distribution lists and emails with lists of people in the To: field. I need to track who is getting what. I copied the names from Outlook, pasted them into a cell in Excel, used Data, Text to Columns Highlighted the cells, Pasted Special using Transpose. Doing it...

I work with a number of distribution lists and emails with lists of people in the To: field. I need to track who is getting what. I copied the names from Outlook, pasted them into a cell in Excel, used Data, Text to Columns Highlighted the cells, Pasted Special using Transpose. Doing it...

...With fd 'Add a filter that includes GIF and JPEG images and make it the second item in the list. .Filters.Add "Images", "*.gif; *.jpg; *.jpeg" 'Sets the initial file filter to number 2. .FilterIndex = 2 'Use the Show method to display the File Picker...

I did read his email. That is why I said I used Edit, Delete. "I highlighted all the rows below the data and did Edit, Delete. I highlighted all the columns to the right of the data and did Edit, Delete."

I just highlighted the data and pressed Delete and saved it. Still 3+ Megs.

That was what was puzzling me. I DID do a delete. I never use clear. I just did it again. I highlighted all the rows below the data and did Edit, Delete. I highlighted all the columns to the right of the data and did Edit, Delete. Still 3+Meg. I even tried copy, paste special, values to the...

GREAT SUGGESTION to copy!! I did a copy and paste to a blank spreadsheet and it went from 3 MEG to 41K.

I received a spreadsheet with just 185 rows and 7 columns and no formulas, but it is a 3MEG file! I have highlighted all rows below the data and deleted them. Then, I highlighted all columns to the right of the data and deleted them and saved the file and it still comes in at 3MEG. What gives?

I haven't figured out how to add an attachment to these messages. First, my background. I am a technical writer with no macro experience so I appreciate your patience. I don't remember where I found this throughly commented macro on one website or another. Next, what I am trying to do...

It is automatically adjusting. I looked at column size to restrict the size, but I didn't see a way to do it. That would be very useful to know. Thanks, Alex

...object. With fd 'Add a filter that includes GIF and JPEG images and make it the second item in the list. .Filters.Add "Images", "*.gif; *.jpg; *.jpeg" 'Sets the initial file filter to number 2. .FilterIndex = 2 'Use the Show method to display the File...

I exported a Project file to Excel with the WBS. Then, I imported into Project after I made some changes. When imported into Project, the WBS numbers that should be indented are not.

I found a solution to my own question. 1. Export the project to Excel. Make sure to include all the columns that you have updated. 2. In Project, add a column for sorting. Numbers are usually better. 3. Add tasks in the list or below it. If you need to add tasks between numbers 20 and 21, add...

...database migrations or for software updates. We have multiple servers and multiple environments on each server. For servers A, B, C, D, and E and *each* server is going to have Dev, Test and Production for a total of 15 server-environment combinations, that is A-Dev, A-Test, A-Prod, B-Dev...

I have a Project Plan that was used for another project and I have zeroed out all the Percent Complete and the Baseline, but when I plug in new Start with the existing Duration, the Predecessors are not calculating. I have shown the project to two other people fairly knowledgeable with Project...

I have a MS Project Plan that was used for another project and I have zeroed out all the Percent Complete and the Baseline, but when I plug in new Start with the existing Duration, the Predecessors are not calculating. I have shown the project to two other people fairly knowledgeable with...

2003 sp3

Have tried Date and Time in Footer from Normal View and Insert, Apply All, but it only appears on the Title page. Have tried Date and Time in Footer in Master View and it does not appear. The date appears on the footer of each page.

I am printing and distributing versions of a PowerPoint presentation for review. I need to be able to see the version of the presentation by having the file name printed with the presentation.