name change

Hello everyone. It has been my understanding that if we referred to a sheet by its CodeName rather than its SheetTab name, then if someone renamed the sheet, it would not cause VBA to fail. With that thought in mind, I have the following code. The purpose of this macro is to open a second...

I have list of names in the format of Last Name, First Name Middle Initial. The problem is not every single name has a middle initial and I am looking to make a formula to put the names in First Name Last Name format. Here is the list and the formula I have so far: Extract first name formula...

Through VBA I am looking at changing the name of my workbook that I will send out to people, then having it sent back to me through a control button. The sending part is fine, but not the naming.... I got that from Microsoft (I know it is for worksheet, but I would prefer the the workbook name...

Hello Everyone, Your help would be greatly appreciated. I am looking for some code that would copy some specific rows and paste them on the same sheet, one below the other, equal to a number put in a separate box. At the same time I would like to rename one of the cells in each copied groups...

Hello, I just renamed a sub procedure in a VB macro from "Sub DropDowns()" to "Sub ProbeSelect()". The macro is written to control a series of Form Control Combo Boxes (hence the name DropDowns) that were embedded in the worksheet (not on a Userform) but I changed a few of the Combo Boxes to...

I get data from several sources everyday, and input the data into my workbook. Each data source has a list of names and with this list of names comes a common difference everyday. For example: Site 1 data: Jim Beam Site 2 data: Jim Beam Jr. Site 3 data: Jim Beam Jr This occurs with several...

I apologize in advance for any noob poster mistakes - I am very novice, trying to edit an Access database. I am trying to upload .xlsx data by changing a hard-coded workbook and worksheet name to a more flexible one. The worksheet name includes a date that will be changing every time this is...

Dear Friends, I am using a macro for formatting and sorting (based on a particular column value) for more than 1000 of files (wbk). The problem is i have to rename each time i run the macro in the code for the renamed "sheet1".Kindly suggest some way where i do not have to rename it every...

Hello everyone... Here is what I have The first sheet is titled Totals - on this sheet I have a summary sheet of the data from the other sheets in the workbook. Cells A2 - A36 are 5 weeks worth of dates in text format (ie 10-1-11). Each daily sheet has the sheet name in G2 as...

Hi All! I'm using Excel 2003, and Windows XP, anyway i think this might be an easy question. I have a good file where I pulled some figures ranged in names based on a concatenate data on other tab. I've used "names" for the different ranges of data. The cells c$2 to C$4 are "criterias" used...