Actually Vinay's answer is complete.It's your question that is incomplete.
You asked:Is it possible?
Vinay is correct. Yes, it is.
Your "statement of intent" is unclear.
You said "I want to create a Macro" That's pretty clear. Go right ahead, let
us know how that works out.
then: " cells that beginning with *, that he automatically deleting all that
cells"
Now THAT's a bit confusing.you want to delete ALL CELLS if one of them begins
with a "*"??
Technically, we don't "delete" cells.If you tell Excel to delete a cell, it
really just removes the contents and shift the rest of the cells (either moves
them up, or to the left).
So, if I were forced to guess, you really just want to check a range of cells
and delete the contents of any cell that begins with "*".
THAT's fairly easy.simply evaluate the contents of each cell in a range of
cellsand check the left-most character.
One way would be:
Sub Delete_CellValues()
Dim Target As Range
For Each Target In Range("E1:F100")
If (Left(Target.Value, 1) = "*") Then Target.ClearContents
Next Target
End Sub
If you actually meant to delete the contents and shift the cells,or even to
delete an entire row, then you'll need to modify the macro.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
From: Mesut Yilmaz <prince__me...@hotmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Wednesday, September 9, 2015 10:23 AM
Subject: Re: $$Excel-Macros$$ Creating Macro
Can you explain?
Op woensdag 9 september 2015 10:01:58 UTC+2 schreef Vinay Saraf:
yes
On Wed, Sep 9, 2015 at 1:00 PM, Mesut Yilmaz <prince...@hotmail.com> wrote:
Hello All,
I want to create a Macro that, cells that beginning with *, that he
automatically deleting all that cells.. Is that posible? --
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/ discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros...@ googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.
Visit this group at http://groups.google.com/ group/excel-macros.
For more options, visit https://groups.google.com/d/ optout.
--
Thanks & Regards
CA Vinay Saraf
9873697167
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
