range selected

  1. F

    Select column using cells

    Hi, I have loop, where I want to select column starting from AF till to AQ: AF2:AF100 then AG2:AG100 then AH2:AH100 etc.... .... For i=32 to 43 last_rowx = ws.Cells(Rows.Count, "A").End(xlUp).Row ws.cells(i,2)...??? next i
  2. girapas

    Go to specific range with locked cells

    In Sheet1 I have 4 buttons to call the corresponding sub (say page1, page2, page3, page4) that goes to a specific range in Sheet2 (say rng1, rng2, rng3, rng4). I use the following code: Sub page1() Set rng1 = ActiveWorkbook.Worksheets("Sheet2").Range("B1:J20") Application.Goto rng1, True...
  3. M

    Highlight cells or ranges in edit mode (F2) on multiple sheets

    Hello friends, I'm frequently editing long formulas like this: =SUMPRODUCT((Info!$W$70:$X$104)*($B6=Info!$A$70:$A$104)*(AC$5=Info!$W$69:$X$69)) When I'm in edit mode (F2) modifying the formula in the current sheet, I can see the used cells and ranges highlighted with different colors in the...
  4. L

    Teacher Grading sheet with variable formatting

    Hopefully there is an easy solution that is alluding me. What I have is a sheet that has different questions represented by each column, students and their answers in each row. I need to compare the answer for each student with the correct answer at the top of the column. If the answer is...
  5. F

    VBA if cell in range is selected then call macro

    If a cell in range is selected or changed I would like a macro to run. For example, If any cell is selected or changed in range("a2:c20") then (macro). Any help would be much appreciated. Thanks in advance.

Some videos you may like

This Week's Hot Topics