Sheet is protected and certain cells are unlocked. (The ones you can get to
are unlocked). The sheet must be protected or the locked and unlockj feature
will not work.
On Sat, Apr 9, 2011 at 8:14 AM, Rambabu Mudiraj rambabu1...@gmail.comwrote:
Dear Friends,
Help needed in Cells Protection
=+IF(B2=35000,B2*20%,IF(B2=35000.01*40%,IF(B2=14,B2*50%,)))
not 100% sure what your after see if this is close.
On Sat, Apr 9, 2011 at 6:49 AM, srinivas m srinivas.m4...@gmail.com wrote:
Hi Team,
This is srinivas.
I am working in a MNC company. I need to calculate tax for UK employees
Pl. explain what is *=_xlfn*.???
Is it User Defined function or what else?
Regards,
Dhanajay
On Sat, Apr 9, 2011 at 9:22 PM, ashish koul koul.ash...@gmail.com wrote:
sumifs function is avaliable in excel 2007 onwards check out the link below
Hi Friends,
I am UAE returned after 27years have got a job in Navi Mumbai as Admin. HR
Manager.
Please support me with info. tips Excel Files that would be helpful to me.
Looking forward for your help assitance.
Reply to me at vas...@gmail.com
Thanks
Vasi S.
MIDC Taloja
Navi Mumbai.
--
Hi,
I want a macro to copy each worksheet in a Workbook in specific folder Say
H:\31.03.2011_10.04.2011 with File name as name of the active worksheet
time of generation. For Example: My Workbook contains 35 sheets named
(Brazil,India,US etc) and i ran the macro at say 04:00 then it should Save
Dear Mr. Vasi,
I hope this will be help you for sure. Kindly register yourself on
www.citehr.com and you will be able to post your queries and get solutions
for them.
Anyways Congrats for your New Job in a new Destination.
Regards
Ahmed Bawazir
On Sun, Apr 10, 2011 at 11:16 AM, vasisd
see if it helps
change
pathbk = C:\Documents and Settings\achamanlalko\Desktop\eforms\eform
reports\test workbook\ to the destination folder
Sub createworkbooks()
Dim i As Long
Dim a As Workbook
Dim z As String
Dim pathbk As String
pathbk = C:\Documents and
_xlfn IS
http://office.microsoft.com/en-us/excel-help/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-HA010204569.aspx
On Sat, Apr 9, 2011 at 11:02 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Pl. explain what is *=_xlfn*.???
Is it User Defined function or what else?
Regards,
Hi All,
I've got some code that's a bit buggy for a stock analysis
spreadsheet, and in need of some help. For some reason, I experience
an error at If Cells(6 + i, 12) Then and would appreciate
any help in fixing it. Many thanks for your help in advance.
Best, V
_
Sub List()
Dim i