Dear Guys
Thanks for the response.
Need one more help.
I have 2 worksheet in one file and both are linked to each other. I did the
same as explained by you and was successful. Now for the second worksheet,
if i need to lock only one coloum and unlock the second coloum, is it
possible?
EX -
el-macros@googlegroups.com
>Sent: Thursday, December 18, 2014 12:52 AM
>Subject: $$Excel-Macros$$ Need urgent help
>
>
>
>Hello friends,
>
>
>Thanks to all members in advance.
>
>
>I have query regarding microsoft word. it is 60 page project file, 15-40 pages
>fixed like
Hello friends,
Thanks to all members in advance.
I have query regarding microsoft word. it is 60 page project file, 15-40
pages fixed like to be locked.
I want to edit between 1 to 14 and 41 to 60. is it possible?
Please let me know. if you have further question regarding the same
question.
te:
>
>> add below "Microsoft Scripting Runtime" library from tool-->reference
>>
>>
>> --
>> *From:* Indrajit $nai
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Monday, August 19, 2013 4:08 AM
t $nai
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, August 19, 2013 4:08 AM
> *Subject:* $$Excel-Macros$$ Need urgent help on macro error.
>
> Hi All,
>
> Kindly find attached the macro based data collection file.
>
> But when I am running the macro it's showing the
add below "Microsoft Scripting Runtime" library from tool-->reference
From: Indrajit $nai
To: excel-macros@googlegroups.com
Sent: Monday, August 19, 2013 4:08 AM
Subject: $$Excel-Macros$$ Need urgent help on macro error.
Hi All,
Kindly find
Try to add this
Dim FSO as Object
Then replace your line code to :
Set FSO = CreateObject("Scripting.FileSystemObject")
On 19-08-2013 5:38, Indrajit $nai wrote:
Hi All,
Kindly find attached the macro based data collection file.
But when I am running the macro it's showing the some error. K
On 7/4/12, NOORAIN ANSARI wrote:
> Dear Mangesh,
>
> Please put it in Module after press Alt+F11.
> Then we can use it under Activeworkbook.
>
>
> On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay
> wrote:
>
>> Thanks Noorain Where should I put this code. I mean in module or any
>> the place to run th
Dear Mangesh,
Please put it in Module after press Alt+F11.
Then we can use it under Activeworkbook.
On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay wrote:
> Thanks Noorain Where should I put this code. I mean in module or any
> the place to run the code.
> Please tell me detail as u know very wel
Thanks Noorain Where should I put this code. I mean in module or any
the place to run the code.
Please tell me detail as u know very well I am new to VBA.
On 7/4/12, NOORAIN ANSARI wrote:
> Dear Mangesh,
>
> Please use it
>
> *Function Test(rng As Excel.Range)
> If rng.Value <> "" And rng.Value <
Dear Mangesh,
Please use it
*Function Test(rng As Excel.Range)
If rng.Value <> "" And rng.Value <= 24 Then
Test = "<24 Hours"
ElseIf rng.Value <> "" And rng.Value > 24 Then
Test = ">24 Hours"
Else
Test = ""
End If
End Function
*
On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay wrote:
> Hi Friends/
Hi Friends/Ashish,
How will you put this formula in vba code. please tell.
On 7/4/12, Mangesh Vimay wrote:
> Thank you so much mere bhai u saved my job
>
> On 7/4/12, ashish koul wrote:
>> = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours"))
>>
>>
>>
>> On Wed, Jul 4, 2012 at 7:35 PM, M
Thank you so much mere bhai u saved my job
On 7/4/12, ashish koul wrote:
> = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours"))
>
>
>
> On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
> wrote:
>
>> Hi Friends,
>>
>> Please find the attached sheet for if statement.
>> Please help me dear all
= iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours"))
On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> Please find the attached sheet for if statement.
> Please help me dear all !!!
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for
Hi Friends,
Please find the attached sheet for if statement.
Please help me dear all !!!
--
With regards,
MaNgEsH
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
well friend i´m learning by recording and then studying the code, there are
many books, but i don´t like them very much, too much writing confuses, i
prefer to see "live" excel and study them and test them, i find very useful,
Ashish Koul blog and twitter, it´s being very useful to my learning, mos
Hi,
I want to learn VBA Excel so what is the path that should i follow ,does any
book will help or what means i despretely learn VBA ,so please help me how
to learn
--
syed aliya
--
--
Some important links for exce
Process flows as follows
Call center make appointments
Generate the appointment file by clicking export button & send the
file to call centre
Call center manger receive all the files from tele marketers and do
quality check ( approved , rejected , reschduled )
rejected appoints goes to tele
Hi Experts,
Please help in this concern,
Is there a solution to copy the excel data from web, i need to copy the
excel data from website i tried this option from excel 2007
DATA-->From web
But some error is poping up.. Please advise any macro to reduce this
criticality, i need to copy literall
Dear Sharma,
I have no idea of your requirement but the file seems to be like willing to
know the password predictions algorithms. Or Hacking password techniques.
Please clarify on this or correct me if i failed to understand your file.
Thanks & Regards
Ahmed Bawazir
On Mon, Jan 3, 2011 at 11:14
this does the trick...
Paul
>
>From: Born to Win
>To: excel-macros@googlegroups.com
>Sent: Thu, December 9, 2010 6:23:02 AM
>Subject: Re: $$Excel-Macros$$ need urgent help
>
>yes exactly
>Thanks,
>Chandrabhan Singh
>
>
>
>
>On Tue, Dec 7, 2010 at 7:21 PM,
gt; *From:* Born to Win
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, December 7, 2010 3:05:56 AM
> *Subject:* $$Excel-Macros$$ need urgent help
>
> Hi Expert,
>
> i have a challenge when i am going to open a new excel file i am not able
> to open that file directly ho
Are you saying that you have an EXISTING Excel file,
when you double-click, it doesn't open,
but if you right-click, there is a menu that allows you to open the file?
>
>From: Born to Win
>To: excel-macros@googlegroups.com
>Sent: Tue, December 7, 2010 3:05:56 AM
>Subject: $
Hi Expert,
i have a challenge when i am going to open a new excel file i am not able to
open that file directly however after right click then its working.please
let me know what i should do to change that configuration.
Thanks,
Chandrabhan Singh
--
-
hi
check the attachment see if helps .it will copy whole pdf documnet
make sure you change this path according to ur pdf setup.
"C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe"
On Thu, Nov 18, 2010 at 2:39 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Hi fri
Can anyone help me please...
Thanks,
Manoj Kumar
On Mon, Apr 19, 2010 at 1:01 AM, Manoj Kumar
wrote:
> Hi Guys,
>
> I need a macro to calculate total distance between two states or
> cities or both from a distance search engine.For example:-
> http://www.mapquest.com/.
>
> Appreciate ur help.
Hi Guys,
I need a macro to calculate total distance between two states or
cities or both from a distance search engine.For example:-
http://www.mapquest.com/.
Appreciate ur help.
Thanks,
Manoj Kumar
--
--
Some im
Dear All,
Last Day i was contacted by a good consultant,i am not keen join his offer.
if any 1 interested,can use following contact and mail
Contact Person:
CHANDRA SEKHAR
CHAITRA SOFT
#103 l Suresh Harivillu Apartments l Road No.11 l West Maradpally l
Secunderabad 500 026
Tel: 040-4010
Thank you...If possible can u also help us on Finance domain
side. Completed MBA-Finance and having 4 yrs of Exp. in the Financial
Services & Microfinance.
On Thu, Apr 8, 2010 at 3:38 PM, rf1234 rf1234 wrote:
> Hello Dear,
> Here is the files without zipped.
>
>
>
>
>
>
>
>
>
>
>
>
hello sham
your zip file is not woring at my place can u please send it in some other
format
On Thu, Apr 8, 2010 at 1:35 PM, rf1234 rf1234 wrote:
> Hello Dear,
> Carry on Hard Work,Group is here to Help Needy People...
> But Only for Excel,Vba
> :)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope It Will
Hello Dear,
Carry on Hard Work,Group is here to Help Needy People...
But Only for Excel,Vba
:)
Hope It Will Help
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 12:23 PM, saroj.32006 wrote:
> Thank you...Its really a life saving help for the
> needy people.
>
Thank you...Its really a life saving help for the
needy people.
Thank you once again.
On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234 wrote:
> Hello Dear,
> Go through,attached zipped.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
> On Mon
Hello Dear,
Hope u have got some call,if not i have approx 100 consultancy e mail id.
if necessary reply,hope all vba job searcher will be also benefited.
Hope It Will Help.
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 11:23 AM, Baby Patel wrote:
> Thanks Shyam
>
> Will try .
>
> Ch
Hello Dear,
1'st welcome in our group,we are giving helping hands to vba programmers.
2'ns please let us better understand your problem,do u want to change domain
(looking for job) OR Do you want to be a master in VBA.
Please make us understand the problem first.
Hope it Will Help
Happy T
Hi All,
The way this network is responding and working is amazing.
I have many learnt new tips out of this network. .
Also I want to express myself that I am looking for a change.
Am a Quality Ananlyst. 70% of my work is on excle.
Your help in this matter will be highly appreciated.
I am bas
Hi,
PFA file for solution
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Fri, Apr 2, 2010 at 3:45 PM, Baby Patel wrote:
> Hi All,
>
> Can anyone help me providing the quick guide on excel formulas.
>
> I know muchbut want to prepre for an interview.
>
> Also can you ple
Hi All,
Can anyone help me providing the quick guide on excel formulas.
I know muchbut want to prepre for an interview.
Also can you please help me with below problem
there are three columns as follows
post code value 1 value2Value3
WQ1 2GX 2000 3000
WQ15sx5
Hi Sachin,
Have a look at the attached to see if it does what you need.
Regards, and Merry Christmas.
Dave.
Date: Thu, 24 Dec 2009 17:40:36 +0530
Subject: $$Excel-Macros$$ need urgent help
From: sachinmbafina...@gmail.com
To: excel-macros@googlegroups.com
Dear Friend,
Pls find attached sheet
Its OK Anish, I can understand the frustration...
I am also sorry for my hard words..
CHEERS!!
Andy
On Fri, Nov 13, 2009 at 9:09 PM, Anish Shrivastava wrote:
> Thanks Aindril for your help.
>
> N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later
> tht it wasnt a right way..
Thanks Aindril for your help.
N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later
tht it wasnt a right way...was kinda frustrated in office.. :(
On 11/13/09, Aindril De wrote:
>
> Dear Anish,
>
> You would need a UDF for this:
>
> Use the following code :
>
> Option Explic
Hi Anish,
See the attached file. Don't change position of 'Auto Reset', 'Counter' and
'Auto Switch' else it may not work properly.
Also it can be done easily with VBA, so if you need then ask the solution in
VBA and you will get a quick response from the group.
Regards
Sandeep
On Fri, Nov 13, 2
Hi Punit,
Thanks for you helping attempt, but tht's not wht I want. You used just
vlookup in 2 cells...I m afraid to say tht but even I know tht much of
basics (No offence). Could you please let me know wht if the occurance is 3
times. :P
Cheers!!
ANISH
On Fri, Nov 13, 2009 at 3:06 PM, punit pod
Hi
You can use the file attached below:
Punit
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http:/
Hello Experts,
Once agian I am here with a new problem (Thanks for helping me earlier, on
my code).
This time I am stuck with Vlookup, actually I have a list of lot # for which
I have to find TIC # from another table but the problem is it has got
multiple occurances. Our simple vlookup picks the
Hello Experts..
I m using While and Wend statement in my code and it has got more than 100
if conditions. when I run the macro it says "WEND WITHOUT WHILE", it's
buggin my head...and I don know wht's wrong. Could anyone of you please help
me...
Sample code...
Sub dept()
i = 1
z = Cells(Rows.Coun
HI Team,
need a foumula to find the latest Date and in next column the Status
Plz find attached.file.
Thanks in advance.
VR
--~--~-~--~~~---~--~~
--
Some important links for excel users
Hello Team,
I have attached file in which i need a formula in the column E, instead of
the manual ranking in need a formula based on the item mentioned in the
column C.
Please make a note, ranking is based on the largest value to the particular
item in C. ie Glass/Tiles/Bricks
Kindly assist asap.
Dear All,
Please help me.
Attaching herewith the downloaded data. I want to do just text to column.
But when I do this, the data after special character (Square) has been
deleted.
--
Thanks & Regards,
Lavprasad Kori
MIS Executive - Water
Tel. 022 - 39833428
--~--~-~--~~--
48 matches
Mail list logo
