cellsrow

Hi guys, I am not able to get this simple code running.. Sub FillDates() Dim datStart As Date Dim datEnd As Date Dim row As Long datStart = Range("E1").value datEnd = Range("E2").value For row = 5 To datEnd - datStart ' Cells(row, 2) = datStart + row -...

Hi Everyone, Here i am trying to convert multiple columns from numbers to date(Columns are M,N,O) I tried for converting only one column, but couldn't do the same for multiple columns in one Loop. Can anyone suggest me how i can do this....... row = 2 Do While Cells(row, 11).Value <> ""...

I'm trying to calculate the slope of 5 points in a rather large data set. I used this bit of code: Set xl = Range(1, 2, 3, 4, 5) Set yl = Range(Cells(row - 5, col - 5), Cells(row, col - 5)) slopel = Application.WorksheetFunction.slope(xl, yl) I'm trying to the set the range as just...

This was working fine but I added an additional level of case select statements and now I get a 'Case without select' on the 2nd case of the top level Select (in code comments) Thanks for your suggestions. Select Case Cells(row, "AH").Value Case "Y" 'Secondary...

I am trying to take like patterns in cells of a table and copy them to new worksheet. when the matched pattern occurs i need to append the cell in the new worksheet rather than copy over. then i need the script to move to next cell in the row and look for another matched pattern and do the same...

In general, is ActiveCell.Offset(row,col) or Cells(row,col) more efficient in referencing another cell?

Hi there, Stuck with an issue for over a week and need someone to point me in the right direction. I recorded a macro to do a advanced filter and copy the data to another sheet. Works great with one drawback! I have over 3000 rows and created Do While Loop to get the values into 2 different...

I'm trying to enter corresponding part numbers, and I keep getting a Type Mismatch error. The part number in column B corresponds to a part number to be entered in column B. I've hard-coded the numbers and included a couple of the loops here. I want it to go through the CurrentRegion because not...

Hello, can anyone tell me why my code does not work? Sub Cross() Dim nombre As Range Dim rut As Range Dim marca As Range Dim modelo As Range Dim patente As Range Dim motor As Range Dim row As Integer With Sheets("DTT") Set nombre =...

Hey guys I've got a troublesome spreadsheet where strange things happen when the worksheet.change event is supposed to fire... The worksheet has a large table in it, using Excel's built in table functionality. The event, of course, should always fire when a cell is altered - but in this sheet...