
Jeff Carnley
New Member
Members

Forum Posts: 1
Member Since:
November 20, 2015
November 20, 2015

I'm new to VBA and still trying to understand how to write VBA code. So with that said, I have several spreadsheets that have the following value in the cells "+" without the quotes scattered throughout the spreadsheet. What I am hoping to accomplish is create a macro that looks for these cells that have the + value in the cell and delete that cell by shifting the columns to the left. Is this possible?
Many thanks!

SunnyKow
Puchong, Malaysia
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016

Hi Jeff
I would suggest you just use Excel to do what you want as it is easier.
- Click Home > Find & Select > Find, and a Find and Replace dialog box will pop out.
- Input the text "+" (without quotes) that you need in the Find what dropdown list.
- Click Find All. All of the texts you need will be listed in the box.
- Press Ctrl + A to select all of the values in the box.
- Click Close. All of the text that you need have been selected.
- Click Home > Delete > Entire Column (or whatever option you need)
Hope this helps.
Sunny

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Tracy English, David Birch, QSolutions Group
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Jennifer Rodriguez-Avila
Khaled Ibrahim
Kiran Supekar
Lisa Myers
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Forum Stats:
Groups: 3
Forums: 24
Topics: 6530
Posts: 28602
Member Stats:
Guest Posters: 49
Members: 32820
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
