Programming

Macro to rename Tab and then save as
Hi, I'm trying to do a macro thatdoes 2 things: 1- Rename the active Tab with the content of a cell in it dimvar = Date1 Range("AB2").Select (?)Selection.Copy = Date1 ActiveWorkbook.Worksheets.Select (???).Name = Date Range("A4").Select End Sub 2- Then, use this same Tab name and add it... 24 May 2010 19:04

Need Suggestions - Find < 30 days & Mult-Location entries
I’m trying to come up with an approach to mark applicants who have applied with 30 days or have applied at other locations. I have about 5000 rows Column = Name Location Checkin Date Checkout Date Within30 MultiLoc 1. I need to search all records and find where name is duplicated or more than once. Then... 25 May 2010 04:48

Try this - hopefully now readable
Create a new self signed digital signature. After you apply your self-signed signature (from the Visual Basic -> Tools -> Digital Signature... menu, save and close the spreadsheet. When you re-open the spreadsheet you will see the following message below the ribbon/menu bar: Security Warning Data Connections h... 24 May 2010 06:53

Try this
Create a new self signed digital signature. After you apply your self-signed signature (from the Visual Basic -> Tools -> Digital Signature... menu, save and close the spreadsheet. When you re-open the spreadsheet you will see the following message below the ribbon/menu bar: Security Warning Data Connections have be... 24 May 2010 06:53

please help.. highly important...
i have a excel .CSV file that Gmail generated for me with my contacts in.. what i want to do is function that go over all the contacts emails one by one and deletes all missformated addresses that cannot be use to send email for them.. somthing like : if (the cell's text is not an valid email address) { d... 29 May 2010 06:01

Using Trim in a Userform
I have a Userform that I fill out and have the information entered in a cell on a worksheet, I am trying to use Trim when entering it in the cell to remove any duplicate spaces. Can someone help me out and let me know why this isn't working and what I need to change to get it to work. Thank you for your help.... 24 May 2010 06:53

Date programing in a cell
Can you program a cell to disallow entry of same or overlapping dates entered in the same column? ... 23 May 2010 12:29

Drill down pivot table data via VBA macro
I am trying to create a macro that will drill down subtotals from a pivot table. Since the number of rows, and colums, changes frequently I need to reference the total for the row or column. Can this be done via VBA macro? -- jmon76 ------------------------------------------------------------------------ jmo... 23 May 2010 19:04

can i create a reminder to pop up in excel?
Hi FSt1 I have same prob I want to set up a reminder in excel, this reminder must pop up 2 days before my appointment. But this pop up has to show in desktop without opening excel I have too many bills have to pay befor due date but forgot the date. There is any way to pop up comes on or before due date whi... 25 May 2010 15:47

Save in different folder
I want to save a workbook in a different folder. The folder already exists, and I want to use the same file name. What is correct code to do this? ... 22 May 2010 17:08