s Long
>> 'col A
>> Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g")
>> 'other columns
>> For i = 2 To 5
>> fr = Cells(2, i).End(xlDown).Row
>> lr = Cells(Rows.Count, i).End(xlUp).Row
>> Cells(fr, i).Resize(lr).Copy Cells
Hi
Thank u for ur reply, still I need some more changes in the code, pls
check the attached xl file, it will show step by step what to do.pls
make the necessary change in the code for getting the result.
Sub CopyColumnsToTableSAS()
Dim i As Integer
Dim fr As Long
Dim lr As Long
'col A
Cells(2, 1).R
xlDown).Row
> lr = Cells(Rows.Count, i).End(xlUp).Row
> Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
> Next i
> End Sub
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message-
> From: Rajesh K R
> Se
Hi experts
Find the attached file,and help me to create a macro to format a table
from the data given.
My idea to solve this
select column A:E, & paste in G1
Select blank cells in column B ,here B2:B26 & Deletethem
Repeat the sale in next columns
Regards
Rajesh Kainikkara
--
FORUM
Hi
Thanks for ur reply, but i need a format like which add in attached file.
Regards
Rajesh Kainikkara
On 3/13/12, Aivi wrote:
> PFA..
>
> ReGaRdS
> AiVrAn kUmAr
>
> On Tue, Mar 13, 2012 at 9:46 AM, Rajesh K R
> wrote:
>
>> Hi experts,
>>
>> I have
Hi experts,
I have a large data in Tally 7.2,when i try to I got data in a
different format, please check the attached file "Sheet 2" and make a
solution.
Thanks in advance
Rajesh Kainikkara
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poo
riginal Message-
> From: Rajesh K R
> Sent: Monday, September 12, 2011 1:51 PM
> To: excel-macros
> Subject: $$Excel-Macros$$ Look formula to select ledger group
>
> Hi Experts,
>
> Is there any formula we can use to select matched texts just like
> sumif formul
Hi,
I was not aware of that.Thanks for information.
Regards
Rajesh Kainikkara
On 9/13/11, dguillett1 wrote:
> I would strongly suggest that you not try to break this password UNLESS
> poster can PROVE ownership. Legal problems
>
> -Original Message-----
> From: Ra
Hi,
Pls send me the file, I will try.
Regards
Rajesh
On 9/12/11, channa srinivas wrote:
> hello everyone
>
> i have created a macro and protected it
> and i forgot the password
> is it possible to view the code??
> please help
>
> thanks
>
> srinivas
>
> --
> -
Hi Experts,
Is there any formula we can use to select matched texts just like
sumif formula(in case of numbers).Kindly find the attached file it
ellaborate well about the issue.And tell me how to solve it.
Regards
Rajesh Kainikkara
--
---
t;> If DateValue(Sheets(1).Cells(i, 1).Value) =
>> DateValue(Sheets(2).Range("a1").Value) Then
>> k = Sheets(2).Range("iv2").End(xlToLeft).Column + 1
>>
>> For j = 2 To 11
>> Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Value
>>
Hi Experts,
Please find the attached file & tell me the code how to select the
date value in "sheet2" cell "A1" in Sheet 1. After selecting the row
then all the data in sheet2 range("B2:B11") have to copy & paste in
the sheet1 colomns("B:K").
Regards
Rajesh Kainikkara
--
--
> Application.EnableEvents = True
> endif
> End Sub
>
>
> Sub Copy_April()
> Flg=false
> Sheets(1).Select
> Range("A1:AG100").Select
> Selection.Copy
> sheets(13).select
> Range("d10").Select
> activecell.PasteSpecial :xl paste special v
> Set DataFilledRange = Application.Union(DataFilledRange, cls)
> End If
> End If
> End If
> Next cls
> With DataFilledRange
> .Locked = True
> .FormulaHidden = True
> End With
> WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
> End Su
xt cls
> With DataFilledRange
> .Locked = True
> .FormulaHidden = True
> End With
> WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
> End Sub
>
> On Wed, Jun 22, 2011 at 3:54 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>>
>> I add a co
Hi Experts
I add a code in the work sheet for the identification of data
selected, But the copy paste is not working in that sheet. How can I
solve the issue,Pls check the code & tell me the change required.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = F
Hi Experts,
I already posted this query, but i think my elaboration was not good.
Now I made the necessary changes in the sample file attached. pls
check it once more and tell me how to solve it.
Regards
Rajesh Kainikkara
--
-
Hi Experts ,
Pls check the attached file .In it I have to protect the cells in
columns "C" to "AG" if it have any data, but the other columns for
entering name or serial number need not want to protect how can I
solve it.
Regards
Rajesh Kainikkara
--
---
= "Physical address: " & objAdapter.MACAddress
Next objAdapter
End Sub
On 5/29/11, Mahesh parab wrote:
> Hi
>
> try:
> For Each objAdapter In colAdapters
> Cells(1, 1) = "Physical address: " & objAdapter.MACAddress
> Next objAdapter
> End Sub
md
>> prompt and find Physical address i.e MAC address
>> check info on below linkhttp://ecs.rutgers.edu/physicaladdr.php3
>> Thanks
>> Mahesh
>> On Sat, May 28, 2011 at 7:16 PM, Rajesh K R
>> wrote:
>>
>>
>>
>>
>>
>>
>>
&
ce.ExecQuery _
> ("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled = True")
> For Each objAdapter In colAdapters
> MsgBox "Physical address: " & objAdapter.MACAddress
> Next objAdapter
> End Sub
>
>
>
> On Fri, May 27, 2011 at
Hi Experts
Is there any code to get MAC address of the computer.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldai
Hi experts,
pls check the attached file and solve my issue regarding ranking the
rooms according they are used for rent. In column "H" I given the
formula for rank it, but it shows wrong values, the answer required
given in column"i".
Regards
Rajesh Kainikkara
--
--
content in yellow are the two conditions
>
> thanks
>
>
> On Thu, May 12, 2011 at 8:51 PM, Rajesh K R
> wrote:
>> Hi Experts,
>> Pls find the attached file and solve the issue regarding if function.
>>
>> Regards
>> Rajesh kainikkara
>>
>
Hi Experts,
Pls find the attachment and tell me how to rank the rooms as per the
collection received from them.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi Experts,
Pls find the attached file and solve the issue regarding if function.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twit
Hi,
Thank you everybody send reply, all are perfect answers.
Regards
Rajesh kainikkara
On 5/11/11, ChilExcel wrote:
> Please see attached file
>
>
>
> By Chilexcel
>
> 2011/5/10 Rajesh K R
>
>> Hi Experts
>> Pls check the attached file and tell me h
Hi Experts
Pls check the attached file and tell me how to consolidate date month wise.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:
t;> Chilexcel
>>
>>
>>
>> 2011/5/9 rajan verma
>>
>>> HI,
>>> Please see if it help..
>>>
>>>
>>> On Sun, May 8, 2011 at 4:01 PM, Rajesh K R
>>> wrote:
>>>
>>>> Hi Experts
>>>> Is it
Hi
The xlsm file is not open in my computer will u send the code inside it.
Regards
Rajesh Kainikkara
On 5/9/11, rajan verma wrote:
> HI,
> Please see if it help..
>
> On Sun, May 8, 2011 at 4:01 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>> Is it possible to crea
Hi Experts
I need code to find the cells in column "A" having date above the date
specified in "C1" then select the entire column and delete it. Then
loop until all the data above the specified period deleted.
Regards
Rajesh Kainikkara
--
--
Hi
Thanks for the formula .
Regards
Rajesh Kainikkara
On 5/8/11, ashish koul wrote:
> =TEXT(a1,"")
>
> On Sun, May 8, 2011 at 4:48 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>> If I want to get the name of month from dates
>> 1/4/11- April
>
Hi Experts
If I want to get the name of month from dates
1/4/11- April
5/5/11 - May
how I can I do it with a formula or code
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow u
Hi Experts
Is it possible to create two buttons one for forward & other for
backward and move to sheets in the order what we used after login just
like we do in a browser.Pls check the attachment
Regards
Rajesh Kainikkara
.
--
-
Hi Experts,
In my worksheet I used a cell to enter my secret password. I made the
file in way that the formulas in that sheet will work only if that
value is correct. I want hide the secret password from others. eg I
need the fonts like or # . How can I do it.
Regards
Rajesh kainikkara
@googlegroups.com
> Sent: Wed, April 20, 2011 12:43:36 PM
> Subject: Re: $$Excel-Macros$$ Show full screen for a particular workbook
> only.
>
>
> You need add ins ?
>
>
>
>
> 2011/4/20 rajan verma
>
> make it add-ins
>>
>>
>>
>>On F
gt; For Each ws In Worksheets
> ws.Unprotect Password:="anystring"
> Next
>
> End Sub
>
> On Apr 15, 7:51 am, Rajesh K R wrote:
>> Hi Experts,
>>
>> I want to password protect my work sheets, but the same time it is
>> necessary to unprotect i
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&quo
Hi Experts,
I want to password protect my work sheets, but the same time it is
necessary to unprotect it for the running of macro so i have to give a
code to unprotect them. how can I do it.
Regards
Rajesh kainikkara
--
--
Hi Experts,
I gave the following code to get the full screen view, if it is only
applicable to that particular workbook how can i change it.
Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub
Regards
Rajesh kainikkara
--
--
Hi
I am also searching for that. u can download freely the tools & codes
to crack the worksheet passwords, but in case of VBA project password
cracking I think it may not be easy.
Regards
Rajesh kainikkara
On 3/28/11, Raveendra wrote:
> Can you explain how to crack password in VBThanks & R
nt
>>
>>
>>
>> On Sun, Mar 27, 2011 at 9:35 AM, STDEV(i)
>> wrote:
>>
>>> please find attached
>>> and see if it helps
>>>
>>> best regards
>>> siti Vi
>>>
>>>
>>> On Sat, Mar 26, 2011 at
tachment
>>
>>
>>
>> On Sun, Mar 27, 2011 at 9:35 AM, STDEV(i)
>> wrote:
>>
>>> please find attached
>>> and see if it helps
>>>
>>> best regards
>>> siti Vi
>>>
>>>
>>> On Sat, Mar 26, 20
attachment is added now
On 3/26/11, vijayajith VA wrote:
> Hai
> attachment is missing
> thanks
>
> On Sat, Mar 26, 2011 at 7:43 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>>
>> How to understand the room status, by color code.pls check the
>> atta
gt; =IF(ISNUMBER($A5),OFFSET(BILL!$D$1,$A5,0),"")
>
> 2
> lookup the table based on RowIndex
> individual formula in a cell
>
> =IF(ISNUMBER($A5),OFFSET(BILL!$D$1,$A5,0),"")
>
>
>
> On Fri, Mar 25, 2011 at 7:40 PM, Rajesh K R
> wrote:
>
On 3/26/11, Rajesh K R wrote:
> Hi Experts
>
> How to understand the room status, by color code.pls check the attachment.
>
> Regards
>
> Rajesh Kainikkara
>
--
--
Some important links for e
Hi Experts
How to understand the room status, by color code.pls check the attachment.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
Hi,
How can I select bill numbers of a particular date and show it in
ascending order using a formula.Kindly check the attachment .
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us o
I3)))
>
> and more..
>
>
>
> On Fri, Mar 18, 2011 at 10:42 PM, Rajesh K R
> wrote:
>>
>> I want to round the value 16.33 as 16.5 and 16.83 as 17 how can I do
>> it with a formula.
>> Regards
>> Rajesh kainikkara
>>
>>
>
> --
>
Hi Experts
I want to round the value 16.33 as 16.5 and 16.83 as 17 how can I do
it with a formula.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and l
Hi Ashish
Thanks for the reply, I need some more change in it, Kindly check the
attachment .
Regards
Rajesh Kainikkara
On 3/8/11, ashish koul wrote:
> see if it helps
>
> On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R
> wrote:
>
>> Hi Experts ,
>>
>> Kindly check
":")))
> - (C2+TIMEVALUE(SUBSTITUTE(D2,".",":"
>
> This will give you the number of days (and partial days) between the two
> dates.
>
> Simply multiply by the number of hours/day (24) gives you:
>
> =((F2+TIMEVALUE(SUBSTITUTE(G2,".",&q
Hi Experts ,
Kindly check the attached file and tell how to calculate the hours of
stay in column "I".
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks a
).Select
> ActiveSheet.Paste
> End If
>
> Next i
>
>
>
>
> End Sub
>
>
> On Wed, Feb 16, 2011 at 8:40 PM, Rajesh K R
> wrote:
>
>> Hi
>> Thanks for ur fast reply, now it copying the data in column"B" if I
>> want to copy the entire
"b1").End(xlDown).Row
> If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> Sheets(2).Range("b" & i).Value) = 0 Then
> Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
> Sheets(2).Range("b" & i).Value
> End
Hi Experts
How can select data from sheet2 which don't exist in sheet1 and copy
the entire raw and paste in sheet1. Pls find the attached file to get
more details
Regards
Rajesh Kainikkara
--
--
Some important links
Sheets("ITEM MASTER").Select
> Range("B2:O200").Select
> Selection.Copy
> Sheets(ShtName).Select
> Range("F2").Select
> ActiveSheet.Paste
> End If
> Next M
> End
t;> Cells(R - 1, 2).Value) Then
> Cells(R, 2).EntireRow.Insert Shift:=xlDown, _
> CopyOrigin:=xlFormatFromLeftOrAbove
> Cells(R, 1).Value = Cells(R + 1, 2).Value
> End If
> End If
> Next R
> Application.Scre
Hi Experts
Here is my issue about inserting raws in a range of cells.
A B C
1 ABC ALPHABETS =IF(B1<>B2,1,"")
2 123 NUMERICS
3 *@& SYMBOLS
I want to insert a raw if the cell value in column B = 1.& copy the
text of column B & paste it in
Hi Experts,
I have a problem regarding sorting and the data.Within my limitation I
tried to sort them based on the group column and insert a raw in the
beginning where the data changes.But I can't write code well.Kindly
help me regarding this issue.
Rajesh Kainikkara
--
Hi Dave
Excellent work, I never thought that the conversion can be done by formula.
Regards
Rajesh Kainikkara
On 2/5/11, Dave Bonallack wrote:
>
> Hi Solomon,
> Have a look at the attached. Most numbers-to-text conversions are done with
> VBA, but this one is done with formulas and functions. It u
perties.
>
> Then select Backcolor from Alphabetic list and choose from the Palette.
>
> ~Susan
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Rajesh K R
> Sent: Saturday, January 08, 2011 11:32 AM
&g
Hi Experts
How can change the color of command buttons
Regards
Rajesh Kainikkara.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
t;
>> Regards.
>>
>> Daniel
>>
>> -Message d'origine-
>> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
>> De
>> la part de Rajesh K R
>> Envoyé : jeudi 6 janvier 2011 16:14
>> À : excel-macros
>&g
Hi
Thanks for the mail, let me know one thing how can get the result in
sheet 1! range"A1"
Regards
Rajesh kainikkara
On 1/6/11, JsinSk wrote:
> Private Declare Function GetComputerName Lib "kernel32" _
> Alias "GetComputerNameA" _
> (ByVal lpBuffer As String, nSize As Long) As Long
>
>
>
Hi Experts
How can I get the the computer name on which the macro is running.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter
e in notepad
> 2.Save it with your desirables name
> 3.Check machine name before opening Workbook/ Else close Workbook.
>
>
> For any problem to doing this stuff,Send me mail..
> Hope it Will Help
>
> On Wed, Jan 5, 2011 at 7:04 PM, Rajesh K R
> wrote:
>> Hi Expe
Hi Experts,
Is it possible to prevent coping a particular Excel work book , from
my computer. I am thinking if the macro has an address like computer
name\d\rajesh.xls it will not work in other computer & other location
without my permission, I don't know is it possible or is there a
better way fo
---
> Ms.Exl.Learner
> ---
>
> On Sun, Dec 26, 2010 at 6:29 PM, ashish koul wrote:
>
>>
>> check the attachment
>> On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R
>> wrote:
>>
>>> Hi experts
>>>
>>> Wish you happy new ye
a to do the work.
>
> Have a look in the attached file.
>
> ---
> Ms.Exl.Learner
> ---
>
> On Sun, Dec 26, 2010 at 6:29 PM, ashish koul wrote:
>
>>
>> check the attachment
>> On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K
Hi Ashish
Thank u very much, for ur fast & perfect answer
Regards
Rajesh Kainikkara
On 12/26/10, ashish koul wrote:
> check the attachment
> On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R
> wrote:
>
>> Hi experts
>>
>> Wish you happy new year
>>
>>
Hi experts
Wish you happy new year
I have worksheet like this
Column A - Date
Column B - Amt
Column C - Name of Month
Column D - For highest value of each month
Column E - For lowest value of each month
Pls check the attached file & tell me
what is the formula for finding the highest & lowest val
Hi Experts
when importing files i got different formated file, how i can get the
data in the same format.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Hi Experts
Is it possible to use a macro in a workbook to another workbook when
that book having the macro is closed.If possible pls let me know how
to do it.
Regards
Rajesh Kainikkara
--
--
Some important links for
Hi Experts
In my file "MAINSTORE.xls" I have a worksheet named "Old Items" have
to import in the file Backup.xls .With in my limitation I created a
macro by recording. The main problem is that it is not importing in a
format that I crated in the file MAINSTORE.XLS.Besides that it is
looks little b
at all)
>
> Either separate the two steps:
> '
> FileName = InputBox("File name, please?")
> ActiveWorkbook.SaveAs Filename:=FileName
> '--------
>
> or remove the variable altog
he trouble.
Regards
Rajesh Kainikkara
On 12/18/10, in.vaib...@gmail.com wrote:
> Yes,
>
> Send your data sheet with ur requirements.
>
> Sent on my BlackBerry® from Vodafone
>
> -Original Message-
> From: Rajesh K R
> Sender: excel-macros@googlegroups.com
> Dat
Hi experts
Is it possible to create a new work book and copy the required to it
from the excising file using a macro.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for
t;
> ---
> Ms.Exl.Learner
> -----------
>
> On Thu, Dec 16, 2010 at 4:08 PM, Rajesh K R
> wrote:
>
>> hi
>> Thanks 4 ur reply,it was a sample what i required, in the actual data
>> its around 300 items in it
>> the data will never in the order
REPORT!A3,DAMAGE!B2:B5)
> 2. The drinks in column A should be in the same order on each sheet.
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la part de Rajesh K R
> Envoyé : mercredi 1
Hi Experts
Pls find the attachment ,& tell me whats wrong in the formula
STOCK SUMMERY - 1 st sheet
OPENING PURCHASESALEBALANCE
COLA 1000 250 700 550
SODA500100 300 300
WATER 400 150
te()
> Dim lastcolumn
> lastcolumn = Cells(1, Columns.Count).End(xlToLeft).Offset(, 1).Column
> Cells(1, lastcolumn).Select
> End Sub
>
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la pa
Hi Dave
The code is working well, Thank u very much
Regards
Rajesh kainikkara
On 12/9/10, Dave Bonallack wrote:
>
> Hi,
> Try this.
>
> Sub Macro6()
> If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect Else
> ActiveSheet.Protect
> End Sub
>
> Regards - Dave.
>
>> Date: Wed, 8 De
Hi Experts
i am want to give an edit button in my worksheet, for protecting &
unprotecting the sheet how can i use it. I try this code but not
working,pls correct it
Sub Macro6()
If ActiveSheet.Protect = True Then
ActiveSheet.Unprotect
Else
If ActiveSheet.Protect = False Then
ActiveSheet.Protect
Hi
i got a mistake in my code here is the correct one
Private Sub Worksheet_Activate()
Dim lastrow
lastrow = Cells(Rows.Count, 12).End(xlUp).Offset(1, 0).Row
Cells(lastrow, 12).Select
End Sub
Regards
Rajesh kainikkara
On 12/7/10, Rajesh K R wrote:
> HI Daniel
> here is the code what i am
, 12).Select
End Sub
Thanks & Regards
Rajesh Kainikkara
On 12/6/10, Daniel wrote:
> Hello.
> Maybe :
> Columns(Day(Date)).Select
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la
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
Hi Experts
I am using an excel sheet for attendance marking sheet have 31 columns
for each day.
if i mark the attendance up to 5th , i want to get select the column
for 6th day automatically when i open the page.how can write the code
1 a b c d e f
2 1 2 3 4 5 6
3 x x x x x
4 x x x x x
Thanks
t) Then Exit Sub
> Sheets(mySht).Select
> End Sub
>
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la part de Rajesh K R
> Envoyé : dimanche 5 décembre 2010 11:31
> À : ex
Hi Experts,
How to solve my problem regarding run time error
Sub Go2sheet()
myShts = ActiveWorkbook.Sheets.Count
For i = 1 To myShts
myList = myList & i & " - " & ActiveWorkbook.Sheets(i).Name & " " & vbCr
Next i
Dim mySht As Single
mySht = InputBox("Select sheet no to copy data for report." & vb
this see if it helps
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Row = 1 And Target.Column = 1 Then
> On Error Resume Next
> Sheets(Range("a1").Text).Activate
> End If
>
> End Sub
>
>
>
> On Sun, Nov 28, 2010 at 5:32 PM, Rajesh K R
>
Hi experts
How can i select a sheet from file having many sheets just type the
sheet name in cell A1 in
sheet1.
Thanks in advance
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER
w, you can not see it using Format->Sheet-> unhide
> To get it, use following code
>
> Sheet1.Visible = True
>
> Further to this, you can protect your VBA code as well, so that no one
> can edit the code to unhide the sheets.
>
>
> Best Regards,
> DILIPandey
>
gt;
> Best Regards,
> DILIPandey
>
>
>
> On 11/22/10, Rajesh K R wrote:
>> Hi Experts
>> is it possible to make file which having hided and unguided sheets and
>> open them using different passwords.
>> Regards
>> Rajesh kainikkara
>>
>>
Hi Experts
is it possible to make file which having hided and unguided sheets and
open them using different passwords.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Application.EnableEvents = True
> Application.ScreenUpdating = True
> End Sub
>
>
> PS: In future please do not send attachments, rather try to elaborate
> your problem efficiently. The group is to help and solve your issues
> not your projects.
> ___
Hi Experts,
Is it possible to use colour index code if i am using a background
color on the sheet,pls find the attatchment and find a solution.
Thanks in advance
Regards
Rajesh kainikkara
--
--
Some important links
Hi Experts
i have a doubt about using macro code for locking and unlocking a file
with a password
pls help me
Regards
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and l
Hi Experts
Pls find the attatchement and find a solution . in the data custom
filtering is not working except
the date 01/10/10 to 10/10/10 .
Expecting your valuable advice
Regards
Rajesh Kainikkara
--
--
Some importa
Experts,
Pls find the attachment and find a solution, in that
filter not working properly in the dates except 10/10/2010 &
11/10/2010, pls tell me the problem & help me to solve it.
Regards
Rajesh kainikkara
On 10/31/10, Rajesh K R wrote:
> Experts,
>
1 - 100 of 107 matches
Mail list logo
