$$Excel-Macros$$ Macro/Script to enter values into cells if the row contains data

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

$$Excel-Macros$$ How to change multiple values

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

$$Excel-Macros$$ Delete rows including blank row except few members

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

Re: $$Excel-Macros$$ Delete rows including blank row except few members

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

RE: $$Excel-Macros$$ playing with several timers with vba excel 2000 ...

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

Re: $$Excel-Macros$$ Delete rows including blank row except few members

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" &

Re: $$Excel-Macros$$ playing with several timers with vba excel 2000 ...

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

$$Excel-Macros$$ Delete rows including blank row except few members

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 -- ---