Very good
On Thu, Apr 11, 2013 at 4:00 PM, Abhishek Jain abhishek@gmail.comwrote:
Attached.
On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi ca.mod...@gmail.com wrote:
Dear All
In the given sheet i want sum on the basis of colour , is there any
formula to solve my problem
regards
Fwd:::
Required Profile
=
*Skill set :* Visual Basic, Expert in VBA for MS Office(Mainly for excel),
Good knowledge of Excel Macro Years of experience : 4-6 yrs Role :
Developer Date of Joining : ASAP
** **
*Location:* Bangalore (Domestic Onsite)
** **
** **
On 7/1/11, L.K. Modi ca.mod...@gmail.com wrote:
Dear Group Members
I need an excel file in wihch by running macro we can see our IP ADDRESS.
Please provide me that file by which we can know the IP address of our
System
Regards
LKModi
--
Dear Ravi,
Please have a view on attached Sheet.
On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Make a Custom List for all names
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *jmothilal
*Sent:* Tuesday,
'HOW TO RUN EXCEL FORMULA USING VBA'
Option Explicit
Sub Function_BY_VBA()
In sheet2 Range c2 Formula will be placed
Sheets(SHEET1).Range(C2).Select
''' ActiveCell.FormulaR1C1 =YOUR EXCEL FORMULA
ActiveCell.FormulaR1C1 = =IF(RC[-2]=60,A grade,B grade)
End Sub
Hello Rajesh,
There is no foolproof method for this.Try to use run security macro
before opening workbook.
Try to do this.To avoid unauthorized use of your workbook.
1.Write the Machine name of Authorized person line by line in notepad
2.Save it with your desirables name
3.Check machine name
of the form clicked OK..
went to master sheet to check the the data. but could see it
On Thu, May 27, 2010 at 1:35 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Accept the input from Vba Form To Sheet Says Master.
And hide the sheet Master with password protection...
On Wed, May 26, 2010 at 2
Accept the input from Vba Form To Sheet Says Master.
And hide the sheet Master with password protection...
On Wed, May 26, 2010 at 2:06 PM, neil johnson neil.jh...@googlemail.com wrote:
Hi Sir,
I make user form in excel sheet. Please check it . I want to add more button
. when Agent enter
.
Regards
Kavita
On Fri, May 21, 2010 at 1:15 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Dear All,
We are here in this beautiful group,where every one is giving the
Helping Hand to Others.
Really Appreciated,I want to add just little,Some persons will at very
great position
Hello Mahesh,
So u have all files in a folder and u want macro to create the
details...
xls name
date created...etc
if it is ok,then let me know perhapes i can help you on this
On Mon, May 24, 2010 at 3:43 PM, Mahesh mahender.bi...@gmail.com wrote:
Dear All,
I have around 200 xls files
for those who are looking Job on
VBA
and thanks for all moderators who are helping people a lot.
regards,
Naniram
On May 21, 12:45 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Dear All,
We are here in this beautiful group,where every one is giving the
Helping Hand to Others.
Really Appreciated
Dear All,
We are here in this beautiful group,where every one is giving the
Helping Hand to Others.
Really Appreciated,I want to add just little,Some persons will at very
great position,they
can help To Give More Efforts.
Please post the job requirements,so that members of our group can be
Hello Dear,
You can use countif in range,attached workbook has a sample formula.
On Wed, May 12, 2010 at 1:30 AM, nyberg75 nyber...@gmail.com wrote:
Hi
How can i sum/count the number of times a name has occured
Example:
John
Bill
Gordon
Bill
Bill
Sara
Bill
John
Result:
Bill = 4
Dear All,
Last time 1 of my friend come to me and ask that he is using to search
? and want to replace it 0
just try it,in range a:a values are,i.e
1
1
1
1
1
1
?
?
1
?
?
?
1
1
?
Now when u will try to search ? and replace with 0,have a look what happen
--
Thanks Regards
Shyam
Software
Dear Sachin
It is already discussed,have a look on previous mail.
Password break
On Tue, May 4, 2010 at 11:44 AM, Sachin Shukla sachina...@gmail.com wrote:
Dear All,
I have sheet which is password protected. I forget the password.
Please suggest me how i open this file and remove the
Hello Dear,
Try the following link
http://www.cpearson.com/excel/topic.aspx
There is a details of all functions and formulas.
On Mon, May 3, 2010 at 8:47 PM, D Kumar dkumar9...@gmail.com wrote:
Hi All,
I am not a perfect in excel but i have a little bit knowledge of some
formulas, is
Dear Paul Schreiner
Your email are very Informative, I like your way to explain.
:)
On Fri, Apr 30, 2010 at 5:34 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
There are many macro available to import specific range.
I.E
It is possible to select all xls file in 1 folder
Dear ugoren
When you have contorls on your sheet,You can't copy the controls in next sheet.
It can be used when you are working with VBA Form.
On Tue, Apr 27, 2010 at 8:08 PM, Uri Goren ugo...@gmail.com wrote:
Hi,
I created a sheet in Excel 2007 and added a few buttons to it via the
form
Dear Vinod,
Have a look in attached Zipped,It will help you.
Hope it Will Help
On Tue, Apr 27, 2010 at 11:39 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello,
I want a conditional formating for the string found to be done in column F
and colour the entire row.
Example
in cell
Hello Dear,
Please let us know,which trading software you are using.
We can help better,when we understand your problem.
On Sat, Apr 24, 2010 at 10:16 PM, nitz gupta rocks.n...@gmail.com wrote:
Dear Friends,
is there a way with which i can convert my excel file to interact with my
Hello Dear,
Following Is The Discription About Sas
SAS Computing
•SAS (software), an integrated software suite produced by SAS Institute Inc.
•Secure Attention Sequence or secure attention key, a method to invoke
a computer operating system's attention, usually signaling it to show
the log on
Hello Dear,
Please send mail with proper subject line and message.Here We are
unable to understand your problem.
we can help better when we know your problem.
On Mon, Apr 26, 2010 at 10:44 AM, ram kumar.m ramsk0...@gmail.com wrote:
--
Thanks and Regard
ramkumar.m
HAVE A NICE DAY
Hello Dear,
Are you looking for dependent list,or you want shorting of data.
Have a look on attached sheet,I hope it will fulfill your requirement.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Wed, Apr 21, 2010 at 4:52 PM, royhamill royham...@sky.com wrote:
Hello,
I
Dear alok
In my knowledge Microsoft not provide any MCA certification by microsoft
Following is the list of certification...
(1)MCTS:- Microsoft Certified Technology Specialist (MCTS)
certifications enable professionals to target specific technologies
and to distinguish themselves by
Dear Rahul
Your suggestion is appreciable,But how can 1 know that other person
is new and he/she wants fundamentals first.
I think new member should ask for fundamental study material with
introducing himself.
On Mon, Apr 19, 2010 at 11:11 AM, lal rahul lal.m...@gmail.com wrote:
Hi
of the said macro(Invoice loader with
Sample Invoice.rar) ?
Regds.
On Thu, Apr 8, 2010 at 10:16 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear
Attached is the macro and sample xls,you can append or import,
Hope it Will Help
Happy To Help
:)
Shyam
On Tue, Apr 6
Hello Dear,
Once i have read this book when i was totally unaware of even
any computer application.
Off course every one learn from his/her experience.
So try this following book.
Stephen Copestake
EXCEL 2003
in easy step
dreamtech press
ISBN:81-7722-505-7
On Wed, Apr 14, 2010 at 11:25
Hello Dear,
Please read and use the following instruction.
Populating Date In Excel
• Populate today's date with the Today function. Type =TODAY() in a
blank cell to return today's date. The Now function returns the date
and the time stamp: =NOW().
• Step 2
Calculate a future date by entering
Hello Dear,
We are not able to understand your problem,what i am getting is ,you
want vba code.u want to fetch interval from now()[End date] and starting date.
Is it ok then reply,so that we can provide you the code.
Hope it Will Help
Happy to help
:)
Prashant Tripathi
On Wed, Apr
Hello Dear,
You can simply read the range,Just use this attached excel Sheet.
Hope it Will Help
Happy To Help
:)
On Wed, Apr 14, 2010 at 4:56 PM, Venkatesan c venkat1@gmail.com wrote:
Dear Group,
Need Assistance for folowing Problam
active cell value is
Hello Dear,
Study materials already provided by admin of this group.
Please try to search in post.
For your 1'st Program,u can try this
Tools--Macro--Visual Basic Editor
or
Alt+ F11
This workbook
'Sample
Hello dear
You can call function in any of event...
i.e
workbook open
button click
sheet active
..
...
Most important is Calling the function.
Private Sub CommandButton1_Click()
call test1
End Sub
Hope it will Help
Happy to Help
:)
Prashant Tripathi
On Sun, Apr 11, 2010 at 6:59
Hello Dear
You can use Multiple if Condition
Conditional Formatting.
Please have a look on attached sheet...
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 10:24 AM, Anil Saxena anilsaxena170...@gmail.com wrote:
-- Forwarded message --
Hello Dear
You can use Multiple if Condition
Conditional Formatting.
Please have a look on attached sheet...
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 10:55 AM, Raj Kumar rajlu...@gmail.com wrote:
Hi Dear,
There is a problem in excel so kinly solve
, 2010 at 10:33 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear
Open this add ins and then your protected workbook.
Follow the instruction.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 10:09 AM, Jai jaihumtu...@gmail.com wrote:
Dear
Hello Dear,
There amy be 2 reason.
1.u have try to update online,the pirated virson got the problem after
updation online.
2.u have try any addins or macro who change the settings.
On Fri, Apr 9, 2010 at 1:03 PM, vikas gupta vikas.63...@gmail.com wrote:
DEAR EXCEL GURUS
I HAVE A
Shyam
Will try .
Cheers
baby
On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
There are some consultancy email id's.This is updated once.
I think you will got the quick response.
i...@bestinfosystems.info
mar...@skillmatrix.net
john.santh...@axheleon.com
Hello Dear,
I have attached to Macro
1.Search Special
2.Search Replace
Hope it Will Help
Happy To Help
:)
Shyam
On Wed, Apr 7, 2010 at 11:27 PM, Liu Yunxia thomas.yunxia@gmail.com wrote:
Hello all,
I'm trying to do a search in Excel for a cell that contains Apple or
Orange.
Hello Dear,
Following is the Code to Protect Unprotect Excel Sheet Using VBA.
''
Sub ProtectSheet()
Dim
Hello Dear,
Nice Article.Appriciate your team spirit.
On Thu, Apr 8, 2010 at 3:02 PM, paulwillekens
paul.johan.willek...@gmail.com wrote:
Hi Vivek,
No need to make a .csv
Open the .txt and Excel will ask whether there is a separator or fixed
length... Choose the latter and on the
. in the Financial
Services Microfinance.
On Thu, Apr 8, 2010 at 3:38 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
Here is the files without zipped.
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 1:47 PM, ashish koul koul.ash...@gmail.com wrote:
hello sham
Hello Dear
Open this add ins and then your protected workbook.
Follow the instruction.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 10:09 AM, Jai jaihumtu...@gmail.com wrote:
Dear All,
Can you Give me VBA Passward Cracker,
--
Thanks For Mail.
:24PM -0700 ^
Hi, I need some help in an export from Excel to Access macro. I have
an Excel tool which will be used by many users. In this Excel, I have
a range, let's say in Sheet 1, A1:B20, that I need to more...
rf1234 rf1234 rfhyd1...@gmail.com Apr 08 10:20AM +0530 ^
Hello Dear
Hello Dear
This is excel 2007 Compatibility issue,
Please contact or chat with Microsoft Specialist
https://support.microsoft.com/oas/default.aspx?gprid=11346st=1wfxredirect=1
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 5:21 AM, Vinod N
Hello Dear
1 of the easiest method is,
Select the range
Data--Filter--Advance Filter--Unique Record Only
For more have the attached Excel Macro.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Fri, Apr 9, 2010 at 1:29 AM, Rajesh Nair nairra...@gmail.com wrote:
Hi All,
Hello Dear
Two ways you can import your XML Data in your Workbook
1. Manually Importing XML Data
2. Programmatically Importing XML Data
Now how to…….
1. Manually Importing XML Data:
1. Start Excel and then click Open on the File menu.
2. In the Files of type list, select XML files.
Hello Dear,
I have check it and find great.It's working nice
great work.
On Wed, Apr 7, 2010 at 4:56 AM, Harmeet Singh harmeet.hew...@gmail.com wrote:
Good one guyz nice to see such creative formulas, here is my share of
knowledge.
Kindly check out the index match function without
Hello Dear,
It is possible to import export using ADO Controls,I am bit Confuse,
How i can send excel data to access when access is not install.
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 6:54 AM, Chechu cecic...@hotmail.com wrote:
Hi, I need some help in an
, Apr 6, 2010 at 11:47 AM, Sarvesh sarve...@yahoo.com wrote:
hi
thanks for your help.
what you are doing is right..but i dont knwo pivot table and how did u do
it...any tutorial for the same...?
regards,
*sarvesh lahoti.*
--- On *Tue, 6/4/10, rf1234 rf1234 rfhyd1...@gmail.com* wrote
Hello Dear,
Attached workbook have the solution for your proble.
Hope it Will Help
Happy To Help
:)
Shyam
On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote:
Hello Folks,
Can someone help me in adding tooltips for each listbox items
selected.
I'm
to excel but like this group much its help me a lot
pls tell me the way how can we use that
as i m clicking on that there is some id type is there and nothing else
please suggest me
Regards
On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
Attached workbook have the solution
Hello Dear,
I do not know. that is there any way,to bypass network security and access that
folder,but if u can save that folder in your pc,then i can provide u the macro,
which will display or list file in particular folder.
Hope it Will Help
Happy To Help
:)
Shyam
On Tue, Apr 6,
VB 6.0
1 Add DriveListBox
2.Add DirListBox
3.Add FileListBox
Resize your above tools on form according to your need.
Dear All,
This post is really helpful for beginers.Appriciate to provide
us a beautiful e-book.
On Mon, Apr 5, 2010 at 11:29 AM, saroj.32006 saroj.32...@gmail.com wrote:
Dear Group, Ayush , Ashish All Persons involved in helping Group,
I really congratulate for making this an Our
Hello Dear,
This problem is alredy discussed in previous post.
try to find out importing txt from notepad to excel.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote:
Dear All,
Need ur advise...
I got around 20 text
Hello Dear,
Here is the attached macro for your problem.
Here string are picked after tab or new line. u can make change
if string are separated by any special character.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 5:06 PM, rf1234 rf1234 rfhyd1...@gmail.com
Hello Dear,
Vishal has provide awesom programming technique to do the same job.
for your more requirement i am sending you addins.just open it at then
that workbook,which have password protection.
Follow the instruction.it is easy and safe.
Hope it Will Help
Happy to Help
:)
Shyam
Hello Dear,
Please reply with full information.What you want to do...
1.send mail from excel
2.send attachment from excel
3.send attachment as current sheet or workbook ,using excel
Every code are different,i.e for different different purpose codes are
different.
So please feel free to let us
Hello Dear,
I can try,i will let you as soon as possible.
Please wait for next post.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara
hkda...@gmail.com wrote:
Hi Frnds,
Can any one break this file's password.
Thanks Regards,
Kumara
Hello Dear
Try to use
tools-- unprotect workbook
tools--unprotect sheets
tools--unprotect share workbook
Password is abc123
Remember this password while working on that workbook.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 5:47 PM, rf1234 rf1234
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
if the topicstarter can provide the raw data it would be helpful
is cusotmizing acc. to need. Now it is like working blind. Any in
depth solution pls free to contact in link.
On 4/1/10, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
I have checked your provided link.It is showing spam free
e
Hello Dear,
if you are looking to permanently lock the project,i think there is no way.
because using hex editor you can break the password.actually i am also looking
to lock my project which can not be broke using hex editor.
Hope it Will Help
Happy To Help
:)
Shyam
On Mon, Apr 5,
Hello Dear,
Please reply with Confirmation,what u r looking for home tab.
we can help better,when we will understand the exact problem.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 10:03 PM, Manisha Jain
manishakothari.j...@gmail.com wrote:
Hi All - Can you
Hello Dear,
try to insert name define
='test'!$D$1:$C1$3000
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 9:26 PM, ChristopherL clusard...@aol.com wrote:
When I tried the below code, for Define I got the Compile error: Sub
or Function not defined
Public
Hello Dear
i am unable to understand this phase
Do I understand you differently from rf1234
please let us know.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Apr 5, 2010 at 10:28 PM, paulwillekens
paul.johan.willek...@gmail.com wrote:
Hi Janet,
Do I understand you
Hello Dear,
I appriciate your prompt reply,it may be a missunderstanding,but please
let me know if any one has a outlook express in his or her PC,Then
what is need to write a macro for outlook(To Send The Mail) .
It is useful when we are accessing outlook from another application.
Your
, kumara datta yagneswara
hkda...@gmail.com wrote:
Thanks alot Shyam,
But it has VBA Password ,will you please help me in breaking that
password.
Regards,
Kumara Datta
On Mon, Apr 5, 2010 at 6:01 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear
Try to use
tools-- unprotect
what can we do
like ram
mohan
shyam
Here we can seprate only nos. but what can we do if we want alphabets
sepreately.
Help in this query.
Thanks in advance
Regards
LKModi
9309243685
On 3/30/10, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Dear All,
Attached is the macro
Hello Dear
Definately you can any formula in macro.
R1C1=Your Formula
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Apr 1, 2010 at 5:10 PM, pushpender nath p.nath.sa...@gmail.com wrote:
Hi Rajesh
We can use any formula in Macro.
Pushpender Nath
On Thu, Apr 1, 2010 at 1:56 PM,
Hello Dear
Try to select range what u want to format.then format cell then time
then desired fromat.
If you are looking this in VBA Macro.Then try to use this.
Hello Dear
If your workbook is in share mode,you can trace the authenticate user,who has
made the changes...
Just try to
check:
Worksheets(Sheet1).OnEntry
If true then report or save the log with user name and machine id.
I am just giving idea,for full programe it will take time.
Hope
Hello Dear,
I have checked your provided link.It is showing spam free
e mail registration.
http://anonomi.com/about/
Now for the topic asked before.
Shimmy you can try dependent list.Reply me if you are new
and want more information.
Hope it Will Help
Happy to Help
:)
Shyam
On
Hello Dear
You can automate your excel workbook,according to need u can write code.
If you are new then you can try to download from net.
Some of the example are available here.
http://www.excel-business-solutions.com/free_download.htm
Please have a view of files,template which are uploaded by
is something, which i am sure i
can give on your every solution
Keep posting such tips :)
Harpreet Gujral
On Mar 30, 5:23 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Dear All,
Attached is the macro to extracting the numeric value from alphanumeric
string.
--
Thanks Regards
Hello Dear,
Following Is the attached macro for your problem.
Hope it will Help
Happy To help
:)
Shyam
On Tue, Mar 30, 2010 at 1:55 PM, Abhidha Dixit abhidha.di...@gmail.com wrote:
Dear All
I am seeking for the reply of one queryy
how to seperate alphats and no.
eg:
Dear All,
Attached is the macro to extracting the numeric value from alphanumeric string.
--
Thanks Regards
Shyam
Software Engineer
Dear All,
A clock indicating the current time is usually displayed in the task
bar of the PC.
One can hide the clock in the task bar if needed. However, hiding the clock does
not mean closing the clock itself. The clock actually runs in the background.
A computer has two clocks; a software
Dear All,
A clock indicating the current time is usually displayed in the task
bar of the PC.
One can hide the clock in the task bar if needed. However, hiding the clock does
not mean closing the clock itself. The clock actually runs in the background.
A computer has two clocks; a software
Hello Dear
Please have a view in..
http://groups.google.com/group/excel-macros/browse_thread/thread/460883072a940f4e
Hope it Will Help
Happy to Help
:)
Shyam
On Tue, Mar 23, 2010 at 4:05 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear
Mail sent macro is already discussed
Hello Dear,
You can use go to reference.Sample sheet with code is attached.
I think it will help you.
Hope it will Help
Happy To Help
:)
Shyam
On Tue, Mar 23, 2010 at 5:19 AM, Spud dean.t...@gmail.com wrote:
Can you post an example showing how the format of the cell values (you
mention
Hello Dear
Mail sent macro is already discussed with code.
Try to execute that code if expiry date condition fulfill.
Hope it will Help
Happy to help
:)
Shyam
On Mon, Mar 22, 2010 at 5:12 PM, ~ Z A H E E R ~ zk9...@gmail.com wrote:
Sorry, Plz read as
Is it possible to integrate MS
Dear All
Please have a look on Delete all hyperlink workbook.
Hope it Will Help
Happy to Help
:)
Shyam
On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram 06n...@gmail.com wrote:
Hi Members,
i have huge data with hyperlinks.
Is there any shortcut key or formula to remove all hyperlinks at once.
Poor calculation speed affects productivity and increases user errors.
Studies have shown that a user's productivity and ability to focus on
a task
deteriorate as response time lengthens.
Excel has two main calculation modes, which let you control when
calculation occurs:
* Automatic
Hello Dear
You can access excel function from vba code.
here is the example
Syntax : ActiveCell.FormulaR1C1 = =Here your function,What you want to Access
Example
ActiveCell.FormulaR1C1 = =SUM(R[1]C[1],R[2]C[1],R[3]C[1],R[4]C[1],R[5]C[1])
Hope it Will Help
Happy to Help
:)
Shyam
On Tue,
***
Speed Up Excel Macro
***
Poor calculation speed affects productivity and increases user errors.
Studies have shown that a user's productivity and ability to focus on
a task
deteriorate as response time lengthens.
Excel has two main
Hello Dear,
I am unable to understand your problem.Please 1'st explain problem.
In your attachment,you have not explain your problem.
Please Reply So that we can understand your requirements.
On Mon, Mar 22, 2010 at 3:27 PM, anil panchal anil.kan...@gmail.com wrote:
Hi All
A
Hello Dear
Attached is the sample sheet, Perhaps it can help you to print achieve
suitable result.
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 19, 2010 at 12:52 PM, OSAVentures Calamba osav...@gmail.com wrote:
Hi All, I'm trying to fill C6 with value of 1 then
Hello Ayush
You have started a good topic,I think in this topic we can share our
some tips and tricks.I am starting a topic ...
''
Diffrence between VBA .NET
Hello All
Some of bug i have remember.trying to share with you.
On Thu, Mar 18, 2010 at 9:56 AM, Ayush jainayus...@gmail.com wrote:
Hello Everyone,
I request you all to share any tips or tricks that you have about MS
Excel in the group. It really helps.
The tip can be anything
Hello Dear,
It depends on which type of security you have there.if u write a code for
protection.
ensure to forcely enabled macro before openning workbook.
On Wed, Mar 17, 2010 at 10:27 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
Each cell has to be locked for protection to
Hello Dear,
You want to do multiple operation in one go.I think this post will help you
out little bit.
Dear All
Below is some defining of Dashboard.
‘’’
‘Dashboard is nothing but a sheet having automation for report generating.
‘’’
dashboard
‘
Dear Harish
Really Helpful Topic.
Happy to Help
:)
Shyam
On Wed, Mar 17, 2010 at 1:28 PM, harish chandru
harish.chan...@gmail.com wrote:
Hi All Hope this helps u all...
http://office.microsoft.com/en-us/help/HA101491511033.aspx - Interactive
page, very useful
Thanks
Hello Dear
Following is the Steps,You can follow.
'
Open Vba
Dear Nasuko
Your solution is available here now,i hope it will work now.
i have rearrange your code now.
Hello Dear,
I have already viewed your problem.
please respond that what you want in pivot column and in pivot row.
Please reply so that we can prepare exact pivot.
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 12, 2010 at 5:25 PM, satya narayana snarayana@gmail.comwrote:
Hello Dear
Great Solution,Really appriciate the team work.
Happy to Help
:)
Shyam
On Fri, Mar 12, 2010 at 10:43 AM, Abhishek Jain abhishek@gmail.comwrote:
-- Forwarded message --
From: Abhishek Jain abhishek@gmail.com
Date: Fri, Mar 12, 2010 at 10:42 AM
Hello Dear
Try To concatenate using operator.
If u want to concatenate a1 and b1 then try to use
=a1/b1
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 12, 2010 at 11:21 AM, Abhishek Jain abhishek@gmail.comwrote:
Dear Ayush,
Thanks.
I thought of this but in Summary sheet
for the code.
I am already doing this.
My main query is after I have made the copies, I want to rename these
files automatically with the names that I have in a list in Excel.
Regards,
Aindril
On Mar 8, 6:30 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
Try to savecopyas
1 - 100 of 135 matches
Mail list logo
