o the first range, since it contains a
different number of cells? Is it always 11 cells more than the range of data in
Columns A & B?
Regards - Dave.
Date: Wed, 8 Dec 2010 13:47:33 +0530
Subject: Re: $$Excel-Macros$$ Error in Macro Code
From: vebhav.j...@gmail.com
To: excel-macros@googlegrou
omate the process.
> Regards - Dave.
>
>
> --
> Date: Wed, 8 Dec 2010 06:51:01 +0530
> Subject: Re: $$Excel-Macros$$ Error in Macro Code
>
> From: vebhav.j...@gmail.com
> To: excel-macros@googlegroups.com
>
> Can someone look into this and sugge
t: Re: $$Excel-Macros$$ Error in Macro Code
From: vebhav.j...@gmail.com
To: excel-macros@googlegroups.com
Can someone look into this and suggest me.
On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote:
Hello,
Can you please help me in making this code in a standard format, instead of
changin
Can someone look into this and suggest me.
On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote:
> Hello,
>
> Can you please help me in making this code in a standard format, instead of
> changing the code daily manually of the highlighted text. Thanks in Advance.
>
> Sub macro1()
> '
> ' Macro1 M
Hi Vebhav,
You say you need to change the highlighted code daily, but you don't say what
you change it to, or on what basis it is changed. We need to know this if we
have any chance of helping you automate the process.
Regards - Dave.
Date: Tue, 7 Dec 2010 22:33:00 +0530
Subject: $$Excel-Mac
t; Sheets(CInt(mySht)).Select
> End Sub
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la part de Rajesh K R
> Envoyé : lundi 6 décembre 2010 17:13
> À : excel-macros@googlegroups.com
> Obj
lundi 6 décembre 2010 17:13
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ error in macro
hi Danial
Thanks for ur reply
i tried ur code but it shows other error (subscript out of range) when
selecting the page.
pls tell me how to solve it.
Regards
Rajesh
On 1
hi Danial
Thanks for ur reply
i tried ur code but it shows other error (subscript out of range) when
selecting the page.
pls tell me how to solve it.
Regards
Rajesh
On 12/6/10, Daniel wrote:
> Hello,
> Try :
>
> Sub Go2sheet()
> myShts = ActiveWorkbook.Sheets.Count
> For i = 1 To myShts
> myLis
Hello,
Try :
Sub Go2sheet()
myShts = ActiveWorkbook.Sheets.Count
For i = 1 To myShts
myList = myList & i & " - " & ActiveWorkbook.Sheets(i).Name & " " & vbCr
Next i
Dim mySht
mySht = InputBox("Select sheet no to copy data for report." & vbCr & vbCr &
myList)
If Not IsNumeric(mySht) Then Exit Sub
S
