Hi Everyone,
I have data in rows("A:A") like . Now I want to delete blank row and *C, D,
E, F till last range in" A". how can I make macros for this *
Name
B
C
A
B
C
A
A
A
A
B
C
C
C
C
C
B
B
C
C
C
D
E
E
F
F
F
--
---
Hi Dave !
first of all, thanks a lot for your response and your example, it
works like a charme !
I'm sorry about the month for responding to you !
again : thanks a lot, it will a super example to learn more about
timers !
José
On 11 oct, 11:29, Dave Bonallack wrote:
> Hi Alfred,
>
> Please do
Try this:
It will delete the entire row when specification meets
Sub processdata()
Dim i As Long, lr As Long
lr = ActiveSheet.UsedRange.Rows.Count
> Application.ScreenUpdating = False
For i = 1 To lr
> If Range("A" & i).Value = "" Then Range("A" & i).EntireRow.Delete
If UCase(Range("A" &
You're welcome.
Regards - Dave.
> Date: Sun, 7 Nov 2010 06:25:05 -0800
> Subject: Re: $$Excel-Macros$$ playing with several timers with vba excel 2000
> ...
> From: jos...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave !
> first of all, thanks a lot for your response and your exampl
HLC
Dear Krishna Mummina,
I saw yr solution to the question of Niel Johnson. As i am a primary
student in Excel I don't know how to create Excel Macro. I would like to
know how to apply these commands in excel and how to use it. Shall I except
yr kind help. Kindly enlighten me using or appl
HLC
Dear Krishna Mummina,
I saw yr solution to the question of Niel Johnson. As i am a primary
student in Excel I don't know how to create Excel Macro. I would like to
know how to apply these commands in excel and how to use it. Shall I except
yr kind help. Kindly enlighten me using or apply
Hello All
Is there any shortcut for changing values in various cells (same
column) to a same multiplier. I am just elaborationg - say in Column A
i have 4, 5, 6, 10 written in first four rows. I want to change these
values to 40% in a single shot. Is that possible? I dont want to copy
and paste th
Hi
I need some help creating a script. I need it to loop through each row
of a sheet and replicate the value from D to O, P, AW and BL. The
number of rows of the sheet will change so I am thinking it will need
a for - next loop to run to the last row and on each loop it will copy
the data from cel
