Browse by Tags

Help w/Excel VBA to search in column, cut and move row to another sheet

I need help to write a vba script to search down one column for rows that contain "Mr." within the cell. Some of the rows could be blank so the search can not end upon reaching the first blank cell (could use a cell containing a key code such as 999). Once the search finds a cell containing...

Posted to Microsoft Office (Forum) by microsoft on 09-14-2009
VBA - Renaming a sheet tab in Excel

I'm trying to find a way in VBA to rename a sheet tab in Excel using the values in a cell for the name. For example, cell A1 is 'Company A'. I would like to rename the tab - 'Company A'. Any thoughts?

Posted to Microsoft Office (Forum) by microsoft on 08-18-2009
Excel, VBA: (Loop) Copy a cell from one sheet if a criteria is met to another sheet

Excel, VBA: I have in fact three challenges: 1) I wish to copy a cell from one sheet to another if a criteria (set out in a different cell) is met. In sheet 1 column C:C lists the criteria 1 for the fields I wish to use, and "" for the ones I do not need. If C1=1 I wish A1 to be copied and...

Posted to Excel (Forum) by microsoft on 08-17-2009
Password protect (lock) a worksheet from VBA

Hi, Is there a way I can lock/protect a worksheet with a password using VBA?... I have a report generator style workbook that exports a new workbook for the user to edit. Some cells (e.g. headings) are locked however the user can edit the report by simply unlocking the cells and changing them. Is there...

Posted to Excel (Forum) by microsoft on 08-17-2009
Open Excel via vba and Sort A specific Sheet

Access 2003 Excel 2003 I want to open an excel workbook, Select a ashett and sort it by Column C I do not need to see excel do this. I can't get this to work Public Sub sortExcel() Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open("C:\DM2007\Export.xls"...

Posted to Access (Forum) by microsoft on 07-27-2009
VBA to copy row contents from one sheet to another

I'm currently using the following VBA code to copy rows from one worksheet to another, when a certain selection is made in a certain cell. ----- Private Sub Worksheet_Change(ByVal Target As Range) If Left(Target.AddressLocal(ColumnAbsolute:=False), 1) = "C" Then InsPos = Sheets("Booked"...

Posted to Excel (Forum) by microsoft on 07-20-2009
Excel Sheet Protection - AutoFilter using VBA

Using AutoFilter with sheet protection. It seems like it is possible to allow AutoFilter in protected sheets but that when you attempt to do the same thing in VBA, it does not work. I set AutoFilter on the row header and set the sheet to be protected ( allowing selection of locked and unlocked cells...

Posted to Microsoft Office (Forum) by microsoft on 06-29-2009
Copy Range of Cells to Another Sheet Using VBA

How do I with VBA copy of range of cell values to another sheet in the same workbook? Thanks, MV

Posted to Excel (Forum) by microsoft on 06-15-2009
Problem: VBA code to insert sheet

Hi, doing up a quick demo for my boss, have done lots of VBA for Word, but not with Excel. I have a few questions, and will ask them one by one really need them answered in the next 30 minutes. 1. How do I insert a new sheet into the workbook. I want to name in "month2" I want it to be inserted...

Posted to Excel (Forum) by microsoft on 06-05-2009
Problem: Using VBA, make the order of sheets in one workbook match the order of sheets in another Excel workbook

I have two Excel workbooks with identically named sheets. Is there a way with VBA to make the order of the names of sheets in Workbook B match the order of named sheets in Workbook A? The result will be that the sheets are in the same order with the same names from left to right in both workbooks.

Posted to Excel (Forum) by microsoft on 06-02-2009

Page 1 of 2 (13 items) 1 2 Next >