cells3

I'm using this code for list some folder i need in my spreadsheet <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console"...

Hi everyone, I want to divide respective cells in one column with other column and obtaining the results in next column using cells reference. Here is VBA code i am using Range(Cells(3, lastcolumn + 6), Cells(5, lastcolumn + 6)).Formula = "=" & Cells(3, lastcolumn + 4) & "/" & Cells(3...

Hi I want to divide respective cells in one column with other column and obtaining the results in next column using cells reference. Here is VBA code i am using Range(Cells(3, lastcolumn + 6), Cells(5, lastcolumn + 6)).Formula = "=" & Cells(3, lastcolumn + 4) & "/" & Cells(3, lastcolumn + 5) It...

Hi Can someone help me to correct my syntax below As i am getting error Wrong number of Arguements or Invalid property Arguement Dim a as Variant Dim matchValueString as String Dim curRow as Long Dim lstRow as Long a = Application.Match(matchValueString, (xWk.Range(Cells(3, curRow), Cells(3...

Hi, Am using the below code it picks the last check in time in the attendance data sheet: Since there are multple check-ins by an employee how do I ensure I am picking the first checkin time Sub Attendance()Dim a, b(), i As Long, ii As Long, n As Long, z As String a =...

Hi there, I am creating a macro that requires a formula to be auto-filled across the spreadsheet to the last column with data in it. The number of columns varies. I have tried the following: Dim LastColumn As Long Range("Q3").Select ActiveCell.FormulaR1C1 =...

HI Why do i get an error on this formula? Cells(3, i).Formula = "=INDIRECT('Data 2 (2)'! & ADDRESS($A3,J$1))" Thanks