Dear All
Can Any one help me to write a macro for following things.
In sheet 1 I have more than 200 items.I want to make a sample by choosing
items from this list.
1.I will make a sample " 111" by choosing Items A,C D .(rest items will be
there but the percentage column will be blank.)
2.I will m
It worked perfectly:), 1000 thanks Mahesh
2011/6/1 Mahesh parab
> Hi
>
> Try :
>
> Sub Test()
> Dim ws As Worksheet
> Sheets("Brands").Select
> Sheets("Brands").UsedRange.Copy
> Windows("Comparsheet.xls").Activate
> For Each ws In Worksheets
> If ws.UsedRange.Cells.Count < 1 Then ws.Delete
>
Hi
Try :
Sub Test()
Dim ws As Worksheet
Sheets("Brands").Select
Sheets("Brands").UsedRange.Copy
Windows("Comparsheet.xls").Activate
For Each ws In Worksheets
If ws.UsedRange.Cells.Count < 1 Then ws.Delete
Next ws
Application.DisplayAlerts = True
Set ws = Worksheets.Add(After:=Sheets(Sheets.Count)
Hi guys i have this macro to copy paste sheets to another sheet on another
workbook, can you help me?i need everytime i run the macro to paste it to
the next blank worksheet of the destiny workbook. 1001 thanks in advance
Sub copy_another_sheet()
'
' copy Macro
'
' Atalho por teclado: Ctrl+p
'
Dear Daniel,
Many thanks , its working fine
Regards,
Prashant
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: 26 April, 2011 10:23 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help on Macro
ol) = Item
End If
Next Item
End If
End If
Loop
Close #1
Application.Calculation = inCalculationMode
Application.ScreenUpdating = True
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prashant
Envoyé
Hi Experts,
Please help on the following code, where it is wrong and please correct
Option Explicit
Sub Create_TOC()
Dim wbBook As Workbook
Dim wsActive As Worksheet
Dim wsSheet As Worksheet
Dim InRow As Long
Dim InPages As Long
Dim InCount As Long
Set wbBook - ActiveWorkbook
With Application
.
>
> Hello Guys,
>
> Need a help on writing macro. I am preparing a sheet which has three
> coloumn.
> The first coloumn would have number ranging from 1 to 3. The Second coloumn
> would have certain number varying from 0 to 6( inclusive of demical to 2
> digit).What I need in third coloumn is a f
Hello Guys,
Need a help on writing macro. I am preparing a sheet which has three
coloumn.
The first coloumn would have number ranging from 1 to 3. The Second coloumn
would have certain number varying from 0 to 6( inclusive of demical to 2
digit).What I need in third coloumn is a formula which is b
Hello Guys,
Need a help on writing macro. I am preparing a sheet which has three
coloumn.
The first coloumn would have number ranging from 1 to 3. The Second coloumn
would have certain number varying from 0 to 6( inclusive of demical to 2
digit).What I need in third coloumn is a formula which is b
10 matches
Mail list logo
