Search results

  1. J

    VBA: Check values in sheet

    Thanks for reply. I already found out how to do it.
  2. J

    VBA: Check values in sheet

    Using VBA, I have values in range("A1:Z1"). Is it possible to check value of each cell? Like when any cell in the range has value more than 60, it changes font color to green.
  3. J

    Sheet to sheet

    I apply range("A5") = "sum(A1:D1)" on sheet1 but I need the answer to show on sheet2 range("A5"). How do I do it? Thanks in advance.
  4. J

    Sum row cells value

    I'm new to this. I need to randomly input values into row cells and when press enter key, it calculates the total value and show in another sheet. Example, in sheet1, I input random values in A1,C1,D1,Z1 and when I press enter key, it calculates the total value and appear in the first row cell...
Back
Top Bottom