Tjyylli

Does Prince Arnaud cause someone holding the Princess to lose?

Raising a bilingual kid. When should we introduce the majority language?

What came first? Venom as the movie or as the song?

Why do people think Winterfell crypts is the safest place for women, children & old people?

What is her name?

How to mute a string and play another at the same time

How to make an animal which can only breed for a certain number of generations?

What is the difference between 准时 and 按时?

Why do C and C++ allow the expression (int) + 4*5?

Etymology of 見舞い

Why doesn't the university give past final exams' answers?

How to break 信じようとしていただけかも知れない into separate parts?

Is my guitar’s action too high?

Can the van der Waals coefficients be negative in the van der Waals equation for real gases?

How was Lagrange appointed professor of mathematics so early?

If gravity precedes the formation of a solar system, where did the mass come from that caused the gravity?

Why not use the yoke to control yaw, as well as pitch and roll?

How do I deal with an erroneously large refund?

Protagonist's race is hidden - should I reveal it?

Are Flameskulls resistant to magical piercing damage?

Is "ein Herz wie das meine" an antiquated or colloquial use of the possesive pronoun?

Assertions In A Mock Callout Test

Is Vivien of the Wilds + Wilderness Reclamation a competitive combo?

How to keep bees out of canned beverages?

Runtime Error 13 on cell not in Range

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

0

I am working on a simple spreadsheet that changes characters when you click on the cell, then counts the cells that are of a certain character. I have set the range to only look at certain cells (A3:A27, B3:B27) but anytime I click on row 1 I get a Runtime Error 13. This row is outside of the selected Range. Here is my code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim rng As Range



Set rng = Range("A3:A27,B3:B27")

        If Target.Value = Chr(254) Then

            Target.Value = Chr(168)

            Cancel = True

        ElseIf Target.Value = Chr(168) Then

            Target.Value = Chr(254)

            Cancel = True

        End If

End Sub

microsoft-excel microsoft

share|improve this question

edited 5 hours ago

Gary's Student

14.3k31834

asked 6 hours ago

user1025198user1025198

1

New contributor

user1025198 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am working on a simple spreadsheet that changes characters when you click on the cell, then counts the cells that are of a certain character. I have set the range to only look at certain cells (A3:A27, B3:B27) but anytime I click on row 1 I get a Runtime Error 13. This row is outside of the selected Range. Here is my code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim rng As Range



Set rng = Range("A3:A27,B3:B27")

        If Target.Value = Chr(254) Then

            Target.Value = Chr(168)

            Cancel = True

        ElseIf Target.Value = Chr(168) Then

            Target.Value = Chr(254)

            Cancel = True

        End If

End Sub

microsoft-excel microsoft

share|improve this question

edited 5 hours ago

Gary's Student

14.3k31834

asked 6 hours ago

user1025198user1025198

1

New contributor

user1025198 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am working on a simple spreadsheet that changes characters when you click on the cell, then counts the cells that are of a certain character. I have set the range to only look at certain cells (A3:A27, B3:B27) but anytime I click on row 1 I get a Runtime Error 13. This row is outside of the selected Range. Here is my code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim rng As Range



Set rng = Range("A3:A27,B3:B27")

        If Target.Value = Chr(254) Then

            Target.Value = Chr(168)

            Cancel = True

        ElseIf Target.Value = Chr(168) Then

            Target.Value = Chr(254)

            Cancel = True

        End If

End Sub

microsoft-excel microsoft

share|improve this question

edited 5 hours ago

Gary's Student

14.3k31834

asked 6 hours ago

user1025198user1025198

1

New contributor

user1025198 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim rng As Range



Set rng = Range("A3:A27,B3:B27")

        If Target.Value = Chr(254) Then

            Target.Value = Chr(168)

            Cancel = True

        ElseIf Target.Value = Chr(168) Then

            Target.Value = Chr(254)

            Cancel = True

        End If

End Sub

share|improve this question

edited 5 hours ago

Gary's Student

14.3k31834

asked 6 hours ago

user1025198user1025198

1

New contributor

user1025198 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 5 hours ago

Gary's Student

14.3k31834

asked 6 hours ago

user1025198user1025198

1

New contributor

user1025198 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 5 hours ago

Gary's Student

14.3k31834

edited 5 hours ago

Gary's Student

14.3k31834

asked 6 hours ago

user1025198user1025198

1

New contributor

user1025198 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 hours ago

user1025198user1025198

1