excel vba 2010

Hi! i'm trying to find Error #REF but i didn't manage it to work. and i don't know what is it i'm missing? here the code Dim ws As Worksheet Dim R As Range Dim sCell As Variant For Each ws In ThisWorkbook.Worksheets Set R = ws.UsedRange For Each sCell In R...

Hi there! (I am using Excel 2010) I have a workbook containing several worksheets. Many of the worksheets in the workbook have similar names: for example, "125005A," "125005B," "125005C," "120320A", "120320B," "130211A," "123456A," "123456B," "123456C," "123456D," and "123456E" are all in the...

Hi! i'm trying to creat a macro that add new rows base on date. evertime i hit ctrl+shift+A it will add new row to column A and B. and Column A will get this days of date. and if it go to next month Column A,B,C and D will get new row as well. A get the days date. and Column C got the days...

Dear All, I have a problem with two excel sheets, which I need to synchronize. For example: Sheet1 and Sheet2 I have a table in Sheet1 from row 72, which is automatically get an information from another sheet(call Products). It has a VBA code which take the rows with product details with a...

Hi! I was trying to list file from folder bit i only get 15 rows. It should be about 650 rows? Sub CheckFile() Dim sFolder As String sFolder = "C:\Folder\" Call CheckPath(sFolder) End Sub Sub CheckPath(sFolder As String) Dim sPath As String Dim sFile() As String...

This is for Excel 2010 VBA I have a named range called "Find_Item", when I type something in I want it to search for that name in a range that also contains spaces. If that name isn't there then I want it to jump to the appropriate alphabetical spot. This is the macro I have now, below. It...

Hi I have been searching for a solution for the last few days, but unable to get anything relevant to it. Data Available ( example) 1. One sheet with Name (Main Data) having the Data (with col A having Unique Values) with Validation in two columns (col D & Col E). 2. A pivot table is...

I am trying to create a cell that updates whenever a cell within a set range is selected. The cell will be changed to the selected cell's value. However, I am having problems with the selection change event. Here is what I have so far: Private Sub Worksheet_SelectionChange(ByVal Target As...

Hello. Here is what I want to do... In one worksheet, I have a vertical list of unique part numbers in column A where no part number is repeated and each part number is unique. In columns B through K (10 columns) there are other alpha-numeric text in each cell (one per cell) listed...