You could try something like this:
For Each x In Range(ActiveCell, ActiveCell.End(xlDown))
If Application.WorksheetFunction.RoundUp(x, 0) = 100 Then x.Offset
(0, 1).Copy
Next x
or rounddown or just round
--~--~-~--~~~---~--~~
Visit the blog to download Excel
Thanks dear.
Sorry for late reply as I was on leave due to some domestic problem.
Regards,
Mudassar Ramzan.
- Original Message -
From: Sathish Jalendran
To: excel-macros@googlegroups.com
Cc: kamal@gmail.com ; m...@worldcall.net.pk
Sent: Thursday, February 12, 2009 9:2
Here's what I use. I've also included the macro to remove the outline,
which, oddly enough, works flawlessly.
Sub outline()
' Keyboard Shortcut: Ctrl+Shift+O
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
E
I'm using Excel 2007; I believe your answer is for Excel 2003.
On Feb 13, 11:46 pm, muthu pandian
wrote:
> Hello
>
> Goto Tools--->Option>Allow Cell drag and drop>Let the Check box ticked
> then you can drag, drop and auto fill
>
> regards
> Muthu Pandian.
>
> --- On Sat, 14/2/09, Ma
for this you can create Pivot chart...If you don't know how to create then
you can send a file..so that I can help you in this case.
On 2/11/09, stuartjohnw...@googlemail.com
wrote:
>
>
> Hope you can help. In column B2:B265 I have a list of names, each
> name appears about 4 time each. In colu
