cells3

  1. V

    How to create a spreadsheet based on folder names

    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"...
  2. K

    Division of cells using cells(ij) format

    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...
  3. K

    Hi

    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...
  4. N

    Help to correct Syntax ... Error: Wrong number of Arguements or Invalid property Arguement

    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...
  5. R

    Finding First Check in Time

    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 =...
  6. K

    Autofill Formula Across Sheet to Final Column

    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 =...
  7. O

    indirect formula vba error

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

Some videos you may like

This Week's Hot Topics

Top