Insert this code on the module and just run it
it will remove the password from password protected sheet
password protected means : file which is accessble but you cant change
the format or any formula or structure of the sheet
this will not help on asking password on startup
Regards
Santosh
in excel sheet (password protect) open and press alt+f11 and paste code
.
good luck
On Mon, Mar 15, 2010 at 10:21 AM, Nandkumar kakvipure
nandkumar.hindust...@gmail.com wrote:
Hi Gurus,
How to use please tell me explain
Thanks in Advance
Nandkumar
On Mon, Mar 15, 2010 at
dear helpful experts,
how to find the corresponding value in a column matching 2 criterias.
please help with this look up formula to find the value as per attached
worksheet. many many thanks to all.
thanks
davegla
--
try this:
Option Explicit
Sub test()
Dim stat
stat = xyz(one,two,three, three, 4, 5, 6, 7, 8, 9)
End Sub
'
Function xyz(ParamArray nArray() As Variant)
Dim msg, I
msg = UBound(nArray) elements: Chr(13)
Thanks You Guru
On Mon, Mar 15, 2010 at 12:47 PM, Vikas Chouhan vikask...@gmail.com wrote:
in excel sheet (password protect) open and press alt+f11 and paste code
.
good luck
On Mon, Mar 15, 2010 at 10:21 AM, Nandkumar kakvipure
nandkumar.hindust...@gmail.com wrote:
Hi
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_ccess without U
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.
--
I normally add a LookUp column at the beginning of the table.
This lookup column then concatenates the criterias.
using this method a normal vlookup will work.
Using your example:
1.) Insert extra column before column A
2.) In the new column A add this in cell A3: =B3_C3
3.) Drag this formula
nice documents
Thanks,
Naniram
On Sat, Mar 13, 2010 at 10:43 AM, big smile bigsmile...@gmail.com wrote:
--
-- Subject: Short Keys
--
Mother Teresa:- If we cannot love the person whom we see, how can we love
god, whom we cannot see ?
--
Guys,
Can anyone help me to Get the Median Value in Pivot Table.
Actually I am working on huge data and I have to send the any types of
analysis which is based on Median Values.
Please try it your end.
Regards
Rahul Gandhi.
9711772297
--
On Mon, Mar 15, 2010 at 1:32 PM, OSAVentures Calamba osav...@gmail.com wrote:
dear helpful experts,
how to find the corresponding value in a column matching 2 criterias.
please help with this look up formula to find the value as per attached
worksheet. many many thanks to all.
thanks
Hello there,
I need to have users to select the range in the spreadsheet and use
what's selected to do further action. Is refEdit the right one to use?
The ideal would be: when user selects the range, in the refEdit box it
shows the values in the selected range. For example, A in A1, B in
A2, C
if you find better solutions pls reply
On Thu, Mar 11, 2010 at 10:56 PM, Harpreet Singh Gujral
harpreetguj...@gmail.com wrote:
Hi Imran,
I have followed the following logic:
In Column G, i have entered a IF Statement, which will seek for Text in
columns H to M, as soon as it finds and text
Hello,
I am trying to assign values to an array of doubles, as follows:
Public Function BillTime(cost As Double, i As Integer)
m_task_cost(i)(IterationCount) = cost
End Function
the array is declared and later dimensioned using
Dim m_task_cost() as Double
ReDim m_task_cost(1 To tsize, 0 To
I have two columns with 16300 rows of data. The contents of the
columns all start with an apostrophe (which is not seen in the cell
itself, but only in the entry bar). The dates are either 'mm/d/
or 'm/d/ or 'mm/dd/ or 'm/dd/. Some of them even have a
trailing hh:mm:ss at the
Its Really NIce.Gud One.
chandrabhan Singh
+919711535271
On Mon, Mar 15, 2010 at 10:04 PM, Nani Ram 06n...@gmail.com wrote:
nice documents
Thanks,
Naniram
On Sat, Mar 13, 2010 at 10:43 AM, big smile bigsmile...@gmail.com wrote:
--
-- Subject: Short Keys
15 matches
Mail list logo