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

The purpose of the following macro is to insert screen captures into the right cell of a table move down to the next row and then over the right cell again. It allows you to select a set of image files such as file01, file02, file03, file04, file05. Instead, it inserts the last one selected - in...

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

To use the following macro, I create a table with two columns and some rows and place the cursor in the right hand column. While I have very little experience with macros, I am happy with the following macro as is EXCEPT for the size of image that is inserted into the right hand cells. I am...

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

I work with a group of database administrators that I put together a project plan for 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...

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.