@Rolf Thank you very much for your help. You are sent by angels.
I read your code and tried to self understand the logic because im just a
beginner. I made some remarks. I also pasted here my revised code which i
adopted from many sites to suit my actual situation. I rename
Post_to_summary TO Post
Hi Simon,
If you post your current code, someone can probably suggest the necessary mods.
Regards - Dave
> Date: Tue, 27 Oct 2009 08:12:32 -0700
> Subject: $$Excel-Macros$$ New user VBA to help random sheet
> From: simongall...@googlemail.com
> To: excel-macros@googlegroups.com
>
>
> Hello,
What do you mean by 'Any color?'
On Oct 27, 6:01 am, Bajji wrote:
> Hi Rolf,
>
> Let me put an example:
>
> 1. Assume sheet1 has some information from Cells ranging A1 : G20
> 2. When I run the macro, it should pop user form with 2 input fields
> asking for cell range (example A1 and C6) to colo
Hi there,
I have an excel sheet that has 3 columns with column B containing
duplicates.
What would the vba code be such that when duplicates are found in
column B, the contents of column A are concatenated with the other
duplicates from column B?
As an example:
*Before - 3 columns*
Hold NY
I took another look at your workbook and think I have a reasonable
solution for your Post_to_Summary routine:
Sub Post_to_Summary()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim nPeriod As String
nPeriod = Range("Compute").Cells
I am sorry, but I am still not quite clear. What do you now mean by
'any color'?
On Oct 27, 6:01 am, Bajji wrote:
> Hi Rolf,
>
> Let me put an example:
>
> 1. Assume sheet1 has some information from Cells ranging A1 : G20
> 2. When I run the macro, it should pop user form with 2 input fields
> a
Hello,
I am a teacher and use an excel document that makes tests drawn
randomly from a bank of questions - there are a few list of questions
and the test has q1 picking a random q from bank 1 etc. After a few
questions it goes back and picks again from the first bank... The
banks of questions are
Hi praveen
to disable an ontime event, you need to know the scheduled time.
So, declare a module level variable to store the schedule time. Use the same
to disable the event
2009/10/27 Praveen Khunte
> Hi Everyone
>
> I have used a macro given in site
> http://www.cpearson.com/excel/OnTime.
Hi
If I understood correctly what you are trying to do, I would suggest you to
use "RefEdit" control which you may find in the additional controls dialog
box in form toolbox. It will allow the user to select a range from the
worksheet.
then u can use the following code (supposing the name of the
1. Click "Tools" - "Add-Ins".
2. Check "Analysis ToolPak".
3. Click "OK".
4. Follow the on-screen prompts or instructions.
Regards,
Andy
On Tue, Oct 27, 2009 at 8:57 PM, Shimmy wrote:
>
> Hi excel Gurus, I am trying to calculate ANOVA in excel 2003, I am
> failing to carry out this task. Howeve
Hello,
I've searched, but have been unable to find / figure out how to solve
my problem. Any help would be greatly appreciated!
Each week I receive a new list and I need to break it up into several
sub lists. The problem then comes that I need to sort the sub lists
by an email field (not a pro
Hi excel Gurus, I am trying to calculate ANOVA in excel 2003, I am
failing to carry out this task. However I know how to carry out this
task in 2007, the problem is that my company does not want to install
2007. Is there a way in which I can activate this analyysis in excel
2003. If you could only
Hi Rolf,
Let me put an example:
1. Assume sheet1 has some information from Cells ranging A1 : G20
2. When I run the macro, it should pop user form with 2 input fields
asking for cell range (example A1 and C6) to color
3. Based on the above cell ranges A1:C6, the macro should color(Any
color) the
Hi Everyone
I have used a macro given in site http://www.cpearson.com/excel/OnTime.aspx
This code copy cell D4 and paste to D30 automatically after every 2 minutes
when you press “start timer” button.
But when I press “Stop timer” button, the macro didn’t stop and keeps on
continuing even when w
*Hi Hemant,*
Will surely try it and let you know the results. If it works then this would
be Great.
Thank you very much.
*Hi Dave,*
Thanks mate for explaining the use of "Goto100", I must say as a learner
it is a quite useful info for me.
*Hi Deepak,*
Thanks for suggesting this, I will try wri
The validation macro used by sales tax department is really stupid..
I have not checked your workbook but I have tried a workbook downloaded from
Karnataka state VAT dept.
Every time I download the workbook from their site, they would have changed
it and it will give new error messages.
Try fili
16 matches
Mail list logo
