target.count

  1. C

    Alternate between two characters by selecting

    Hi all, I found this code to alternate between two characters (I use it to go around the autofill checkbox problem) it works great except it changes all the cells in the column instead of just the selected cell. P.S. I'm a real noob in coding, so please be specific :) Private Sub...
  2. R

    VBA not working when sheet locked

    Hi All, The (Incomplete) code below hides rows based on a value of GF3 and works great until I password protect the sheet. How can I get this to work when the sheet is PW protected? I assume the code would have to unlock/lock the sheet each time the macro is ran? If Target.Count = 1 Then...
  3. N

    Change Even involving Table or List Object

    I have a small bit of code I’d like to use listobjectlanguage with. [CODE] Private Sub Worksheet_Change(ByVal Target As Excel.Range)<o:p></o:p> If Intersect(Target, [Z:Z]) Is Nothing Or Target.Count >1 Then Exit Sub<o:p></o:p> Target.Offset(, 1)= Date<o:p></o:p>...
  4. S

    If Target And Or Then - Pointers?

    Hey there guys, I am trying to get this worksheet_Change to work correctly for what I need. I am pretty tired so I am probably not thinking straight. I have a drop-down list in column F, known as Status, it allows me to select a Pending, Pass, Fail, or leave the cell blank as the input. In...
    • spydey
    • Thread
    • date target target.count vba & excel 2013 worksheet.change
    • Replies: 11
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top