see if it help
On Sat, Apr 16, 2011 at 4:55 PM, Dick wrote:
> I have a text box with the following code. But I'm finding it
> difficult for some people to input the correct time by following the
> format. Is it possible to have the text box with 3 different entries
> such as 0/0/0 or 0:0:0. So t
try this
http://www.ozgrid.com/VBA/excel-add-in-create.htm
or
once you will save file as xlam
in excel 2007 goto excel option goto addins-> bottom you will find manage
option choose excel addin and in browse slelect your addin and ok.
and now in macro type your macroname(which will not be visi
try this
Sub method2()
Dim i, j, k, s As Long
s = Sheets.Count
Sheets.Add After:=Sheets(Sheets.Count)
For i = 1 To s
Sheets(i).Select
'change upper row here in this case it will start copying from second row
j = 2
' it will copy till last used row automatically
k = ActiveSheet.UsedRange.Rows.Count
Hi,
Ok i have saved as Add In file on my add In folder, But now how to run the
Add in file.
It may be a basic question but really i don't know how to run the Add in
file.
Plz help.
Prabhu
--
--
Some important li
I have a text box with the following code. But I'm finding it
difficult for some people to input the correct time by following the
format. Is it possible to have the text box with 3 different entries
such as 0/0/0 or 0:0:0. So the curser is set to start at the hour,
then automatically tab to the mi
Hi Experts,
Please provide me the solution for this.
Regards
Gohil
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Linked
Dear Adhish,
Thank u very much.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join o
Dear Ashish,
Thank u very much.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join o
Hi ashish,
Is there any way to keep common code for all sheet?
Because i may have to use this code on various sheet on many time.
On Sat, Apr 16, 2011 at 11:35 AM, ashish koul wrote:
> change
>
> Sheets(1)
>
> as per your requirement
>
> activesheet or Sheets(" name of sheet")
>
>
>
> On Fri
Dear
Please use Pivot Table
Regards
On Fri, Apr 15, 2011 at 12:50 PM, Umed Singh wrote:
> Hi Dear,
>
> I need your help in attached file. Please make for me in macro code
> for in attached file.
>
> i want to selected department and past another sheet for seperately.
>
> --
>
> -
Hi
Thank u very much.
Regards
Rajesh kainikkara
On 4/15/11, JsinSk wrote:
> I pulled your answer from URL listed below, second and third post both
> give different approaches depending on your needs. Below protects and
> unprotects all sheets, if you just need one sheet there are other
> optio
Hi,
Thanks for ur reply
Regards
Rajesh Kainikkara
On 4/15/11, STDEV(i) wrote:
> Sub ABCD()
> Sheets("MySheet").Unprotect "yourpassword"
> --- your program accessing to sheets("MySheet")
> Sheets("MySheet").Protect "yourpassword"
> End sub
>
>
> On Fri, Apr 15, 2011 at 6:51 PM, Rajesh K R
> wr
12 matches
Mail list logo