Respected Excel Guru's
How to make the macro so that
When ever i start the file my cursor goes into that particular cell only.
For EX. Sheet 2 - A494 etc.
The purpose behing this is ex. i have set the target of achieving certain
amount -- so how much
still pending to achieve.
Thanks have a
One can run a Billion Dollars company with Excel without any ERP support.
On Wed, Sep 1, 2010 at 9:41 PM, kamal shah kamal...@gmail.com wrote:
Simply said than done.
An IT Engineer starts career with Excel... reaches level of excellence in
various technology and toolsbecomes Manager/
Mr Salva,
Just open visual basic editor (tools - macros - visual basic editor)
Double click on This workbook in project explorer.
copy paste this code in code window.
Private Sub Workbook_Open()
Sheets(Sheet2).Select
Range(A494).Select
End Sub
Regards,
Kishan Reddy, K
On Sep 2, 9:28
Hi Experts,
--
Pankaj Pandey
Bhopal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hi,
Please use the following code:
*Private Sub Workbook_Open()*
Sheets(Sheet2).Select
Range(A494).Select
*End Sub*
Cheers!
Andy
On Thu, Sep 2, 2010 at 9:58 AM, big smile bigsmile...@gmail.com wrote:
Respected Excel Guru's
How to make the macro so that
When ever i start the file my
I like excel because All office/home work can be put in ONE ie.,
Excel !!!
Elizabeth
On Thu, Sep 2, 2010 at 10:05 AM, johnson john johnsond...@gmail.com wrote:
One can run a Billion Dollars company with Excel without any ERP support.
On Wed, Sep 1, 2010 at 9:41 PM, kamal shah
Hi,
I have a user who has approached me with an Excel coding issue.
Here is the problem and the code. If anyone can run through this and
fix then it would be most appreciated. I simply do not have the
knowledge or skill in this area to assist.
Run-time Error ‘9’: Subscript Out of Range which
Hi Pankaj,
Pl go through this link
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm
Regards,
Andy
On Thu, Sep 2, 2010 at 12:39 PM, Intelligent But Crazy secrets...@gmail.com
wrote:
Hi Experts,
--
Pankaj Pandey
Bhopal
--
subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
__ Information from ESET Smart Security, version of virus signature
database 5417 (20100902) __
The message was checked by ESET Smart Security.
http://www.eset.com
Hi Vasant,
I am trying to create a macro to do this below task to avoid manual efforts.
For more details please refer the below email.
Here is my code-
Sub Movefiles()
Dim a As Integer
Dim fso, f2
With Application.FileSearch
.LookIn = C:\LLF\ Range(A1).Value
.FileType =
Hi
This posting relate to a earlier one regarding birthdays on a excel
sheet.
in column b i got the /mm/dd
column c i got the person name and last name
column d i got the age of the person
in h10 i need every one that has birthday today with theiry respective
age next to the name. since
Sir.
Thanks for your fast reply.
I have put this in View Code. -- but stil it does not work until i press run
in view code.
I have another function also in that as follows
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Hi,
1. You need to press Alt+F11, and open the visual basic editor.
2. Double click on This Workbook
3. Paste the code.
*Private Sub Workbook_Open()*
Sheets(Sheet2).Select
Range(A494).Select
*End Sub*
4. Save the file (For XL 2003 as .xls , or for XL 2007 as .xlsm)
5. Close the file and try to
I am Insurance Advisor
I my self has more then 2000 clients i have made excel as my base
software which helps me to solve my all daily updates.
Even the LIC Private Software is not giving that much satisfaction
need base soultion which Excel gives me.
Even I love this group also from which
Dear All,
I love Excel more than any Software in the World, I'm not alone, millions and
millions of people around the world use it too and, more or less, Love it.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00
15 matches
Mail list logo