pctechguide.com

  • Home
  • Guides
  • Tutorials
  • Articles
  • Reviews
  • Glossary
  • Contact

VBA Macro that Counts the Number of Cells Starting with a Given Letter

There many be times when you need to know how many words start with a given letter. You can easily accomplish this with VBA. We created a VBA macro that lets you do this.

The macro that we developed to do this is shown below.

The Macro that Lets You Count How Many Words Start with a Given Letter

To use this letter, you need to copy and paste the list of words in Column A. Then you need to show the letter that you want to count in column B.

You will need to run the macro by copying it into the Visual Basic editor, which can be found under the Developer tab. You will need to click Insert Module first. Then, click the run button or push F11.

Sub CountCellsStartingWithLetter()
Dim ws As Worksheet
Dim lastRow As Long
Dim letter As String
Dim count As Integer
Dim cell As Range

‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“Sheet1”) ‘ Change “Sheet1” to your sheet name

‘ Find the last row with data in column B
lastRow = ws.Cells(ws.Rows.Count, “B”).End(xlUp).Row

‘ Prompt user to enter the letter
letter = InputBox(“Enter the letter to count cells starting with:”, “Letter Input”)

‘ Validate input
If Len(letter) <> 1 Then
MsgBox “Please enter only one letter.”, vbExclamation
Exit Sub
End If

‘ Convert letter to uppercase
letter = UCase(letter)

‘ Reset count
count = 0

‘ Loop through each cell in column B
For Each cell In ws.Range(“B1:B” & lastRow)
‘ Check if the cell starts with the specified letter
If UCase(Left(cell.Value, 1)) = letter Then
count = count + 1
End If
Next cell

‘ Display the count
MsgBox “Number of cells starting with ‘” & letter & “‘: ” & count, vbInformation
End Sub

Can You Do this Without VBA?

You can still count the number of words starting with a given letter without using VBA. However, you will need to do so in a more roundabout way. The best way to do this is by sorting the column and then copying and pasting all words that you see with the given letter into the first cell in another column. Then, you can see how many rows are filled. You will have to use the undo command or clear the column after. 

This will take less time if you are just doing it once. However, you may want to use VBA if you plan on counting cells like this more frequently. 

We hope this helps!

Filed Under: Articles

Latest Articles

LED Flat Panels

Nearly everyone is familiar with LEDs (light-emitting diodes) from their use as indicator lights and numeric displays on consumer electronic devices. The basic LED is a solid-state device that contains a chemical compound that gives off light … [Read More...]

13 Impressive Stats on the Future of AI

AI technology is starting to become much more important in our everyday lives. Many businesses are using it as well. While he has created a lot of controversy in recent months, Elon Musk had some great things to say about AI. Here is one quote from him on the topic: ““The pace of progress in … [Read More...]

Machine Learning: the Future of the Hotel Industry

Do you operate a hotel chain and want to calculate budgets automatically? Does your hotel need to predict next week's purchase orders or how many reservations are going to be cancelled? Do you want to enable check-ins through facial recognition? All this is possible with machine learning. … [Read More...]

Why Internet Bundles Are the Next Battleground for Gamers

A weak internet connection can turn seamless gaming sessions into frustrating experiences filled with lag, buffering or sudden disconnects. For … [Read More...]

Importance of Inbound Marketing in the Digital Age

A couple of months ago, Zacks reported that Hubspot was starting to make some major changes to its inbound marketing strategy. They talk a lot about … [Read More...]

Damage Control Strategies for Resolving Online PR Crises

Last July, Astrologer faced a major crisis after its CEO went viral at a ColdPlay concert when having an affair. This was just one of the many times a … [Read More...]

AI is Not Killing Computer Jobs Like Doomers Projected

There is no denying the reality that AI technology has played a massive role in disrupting our lives. A growing number of people claim that AI … [Read More...]

Everything You Need to Know About Sourcing Circuit Boards From U.S. Suppliers

In This Article This article includes: Why Source PCBs From the United States?How to Get a Quote From a U.S.-Based PCB ManufacturerThe Top U.S. … [Read More...]

Top Taplio Alternatives in 2025 : Why MagicPost Leads for LinkedIn Posting ?

LinkedIn has become a strong platform for professionals, creators, and businesses to establish authority, grow networks, and elicit engagement. Simple … [Read More...]

Guides

  • Computer Communications
  • Mobile Computing
  • PC Components
  • PC Data Storage
  • PC Input-Output
  • PC Multimedia
  • Processors (CPUs)

Recent Posts

MO Media

An MO disk is constructed by spattering a number of films onto a high-strength polycarbonate resin substrate base - the … [Read More...]

Removal Guide of Speedial – Browser Hijacker

Known to belong to the list of browser hijacker, Speedial, can infect your computer system through entertaining free downloads (promoted online) and … [Read More...]

How to Start a Business in Computer Engineering

Did you know that there are 66,200 computer engineers in the United States? This can be a very lucrative career path. However, you may have an easier … [Read More...]

[footer_backtotop]

Copyright © 2026 About | Privacy | Contact Information | Wrtie For Us | Disclaimer | Copyright License | Authors