Can you post an example? Not sure how a magic square works.
Sam Mathai Chacko
On Jul 2, 9:17 pm, karunanithi ramaswamy era_...@yahoo.com wrote:
HI,
I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
THANKS IN ADVANCE
I have the file stored on Google Docs at:
https://docs.google.com/leaf?id=0B2wwdgJj4ncpYzQ0MTFiNzQtNDAxMi00NGNmLWIzMjMtYmM0NjQyNTY3Y2Nmhl=enauthkey=CLjt6zY
On Feb 23, 4:01 pm, Ken Hansen k.e.hanse...@gmail.com wrote:
Hi all,
I have a Sales Tracking workbook. I have 2 issues that I can't seem
Pandey [mailto:dilipan...@gmail.com]
Sent: Tuesday, September 07, 2010 3:14 PM
To: Vamsi Tatipamula
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide
Sheet
Hi Vamsi,
Thanks for your continuous interest.
The VBA macro
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide
Sheet
Hi Vamsi,
Thanks for your continuous interest.
The VBA macro is working fine in my system and the code which you
have
mentioned is just for testing purpose
: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide
Sheet
Hi Vamsi,
Thanks for your continuous interest.
The VBA macro is working fine in my system and the code which you
have
mentioned is just for testing purpose and is not getting used
anywhere.
The code which is actually
: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide Sheet
Hi Vamsi,
Thanks for your continuous interest.
The VBA macro is working fine in my system and the code which you have
mentioned is just for testing purpose and is not getting used
anywhere.
The code which is actually hiding
-Macros$$ Re: Excel-Macros$$ Protect hide Sheet
Hi Vamsi,
Thanks for your continuous interest.
The VBA macro is working fine in my system and the code which you have
mentioned is just for testing purpose and is not getting used
anywhere.
The code which is actually hiding the rsm
: Tuesday, September 07, 2010 10:45 AM
To: Vamsi Tatipamula
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide Sheet
Hi,
This code is hiding the ASM sheet, which is then can not be un-hide by
a user by menu commands unless the user goes for VBA
@googlegroups.com
Subject: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide Sheet
Dear Kalyan,
Attached spreadsheet has been solved as per your requirement(s).
Note:- Going forward please mark the group as well while marking the query
email to me. By doing this you can get instant response in case
-macros@googlegroups.com; kalx...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect hide Sheet
Hi Vamsi,
Sure.. below is explanation:-
Requirements were to unprotect and unhide a worksheet only if a user
enters correct password to do the same.
What I have done I have
Dear Kishan Reddy
This is a very good tip and many thanks for sharing the same. I knew about
excel clip board for many years but this idea of using Paste all to
combine all sheets is really a magic.
Thanks
Chandru
On Thu, Jul 22, 2010 at 11:36 AM, Kishan Reddy, K
Hi preeti,
This code covers your task, you can run it and enjoy. It was
interesting problem to solve. Please tell us does it work for you.
Sub automate()
Dim i, j, k, n, myfile, mySheet
Call ListWorkSheetNames
myfile = ActiveWorkbook.FullName
Sheets(main sheet).Select
Cells.Select
Hi preeti,
This code covers your task, you can run it and enjoy. It was
interesting problem to solve. Please tell us does it work for you.
Sub automate()
Dim i, j, k, n, myfile, mySheet
Call ListWorkSheetNames
myfile = ActiveWorkbook.FullName
Sheets(main sheet).Select
Cells.Select
Hi Preeti
Please find attached the solution as required, do let me know if something
else is required.
Regards,
Rajender Soni | +91 750 322 55 50
--
--
Some important links for excel users:
1. Follow us on TWITTER
Thanks a Ton.. Nikhil That's a great Help..
On Jul 10, 10:02 pm, Nikhil Shah nikhil201...@gmail.com wrote:
Dear Friends
Here i am sending One URL For Excel - Macro Training in excel 2003.
http://www.familycomputerclub.com/excel/excel2003_macros.html( With Video )
In
welcome to wonderful world of vba :)
Unsure such a PDF exists (least I havent come across it yet myself) -
however Excel's built-in VBA help provides a good starting place
especially when coupled with Google for more examples, code fragments,
tips/etc available from the numerous vba dedicated
And never underestimate the value of the macro recorder. The code may need a
bit of cleaning up, but syntax is all there for you to take in, and reapply in
your own code.
Dave.
Date: Thu, 11 Feb 2010 18:53:53 -0800
Subject: $$Excel-Macros$$ Re: Excel Macros Free PDF
From: jefgorb
Hi Karthikeyan,
You need to clean up the data before preparing Pivot Table. If the data set
is going to be similar in future as well, then I would suggest to use VBA
macro code. If the data is differrent always or is extracted using
different columns and rows then you might want to do the data
good luck friend ! :)
Hemant Hegde
2009/11/1 karthikeyan sankaran karthikeyansankar...@gmail.com
I have download this data from PDF.Now I want to create pivotTable through
this data. http://groups.google.com/group/excel-macros/subscribe
ymusafi,
The following code checks to see whether the cell's contents is
numeric or not:
Public Function Test(cell As Range)
If IsNumeric(cell.Value) Then
Debug.Print Numeric
Else
Debug.Print Not numeric
End If
End Function
Try it in the Immediate Window by typing:
*see attached file*
On Wed, Sep 2, 2009 at 1:37 PM, ymusafi ymus...@gmail.com wrote:
Hi All
I want to create a macro that is doing somthing if the cell value has
non numeric value
meaning:
if cell.value=???then
I just need to know what to put instead of the question marks
Thanks!
Hi Everybody,
I have created a macro in personal macro workbook, and saved it, it worked
very good as per my expectation, but now
when I run again the macro, it did'nt work the message like Personal Macro
workbook should be open.
Is there anybody to help me ?
REHAN BAIG
for that you need to open the personal workbook in order to run a macro
from any workbook... you need to have that workbook open
i have windows 7 installed and excel 2007... so the path for personal
workbook for me is the below..
C:\Users\Vivek\AppData\Roaming\Microsoft\Excel\XLSTART\
Try to use shortcut key.*Shift + Space Bar*
On Tue, Aug 4, 2009 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote:
Dear All,
Is there any option that when I select a cell in the sheet, the whole row
corresponding to that cell is highlighted.
In the attached example I have selected cell
I don't know that there is any OPTION for this, but
I have done it before with a MACRO.
but there are a few tricks
I use the Worksheet_SelectionChange event.
First, record a macro in which you clear all formatting (highlighting)
then highlight the row you wish to highlight.
this will get you
Hi Sanjay,
If you are using Excel 2003 then keeping your cursor in the data and then
clicking Ctrl+A would choose the whole range of the data where your cursor
is placed...Try doing this while recording the macro, It will work.
Thanks,
Shreedar
On Thu, Jul 2, 2009 at 12:27 PM, SANJAY SONI
Hi All
Can anyone send me a ppt or an overview abt macros
i want to learn the basics of macros. Please help me
Thanks Regards
Anil Kumar
Executive - Database
SOLUTIONS DIGITAS
3rd Floor, Chandra Bhawan, 67-68, Nehru Place | New Delhi - 110019 | India
Mobile: +(91) 9211851980 | Email:
Hi Mayank
Please refer to the group's files section and online resources. You
may search through excelitems.com too.
Excel VBA Learning Files -- http://groups.google.com/group/excel-macros/files
Website -- http://www.excelitems.com
-
Regards
Ashish
Hi Mayank,
please look into the site.
http://www.vbamacros.blogspot.com
regards
Hari Kumar
On Mon, Jun 1, 2009 at 7:16 AM, mayank khare mmayank2...@gmail.com wrote:
plz replyyy
On Mon, Jun 1, 2009 at 7:13 AM, mayank khare mmayank2...@gmail.comwrote:
Hai,
I want to learn indepth excel
plz replyyy
On Mon, Jun 1, 2009 at 7:13 AM, mayank khare mmayank2...@gmail.com wrote:
Hai,
I want to learn indepth excel macros.
Plz tell the resource to learn this.
I do not know any language ie Visual Basic ,which i know is required to
write a macro.
Plz guide me.
--
Warm Regards
workbook, and see if it does what you want.
I've added a button to run the macro from the sheet, but you may want to run
it some other way.
I've left your formulas as you had them.
Regards - Dave.
--
Date: Tue, 26 May 2009 18:33:57 +0530
Subject: $$Excel-Macros$$ Re
You're welcome.
Date: Wed, 27 May 2009 11:11:24 +0530
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
From: atul.kesa...@gmail.com
To: excel-macros@googlegroups.com
Hello Dave,
You are a rock Star...thanks a ton!!!
The macro is awesome.this is what i wanted
Hi Atul,
Sorry about that.
Try the modified attached.
Regards - Dave.
Date: Wed, 27 May 2009 14:08:38 +0530
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
From: atul.kesa...@gmail.com
To: excel-macros@googlegroups.com
Hello Dave,
One small issue in the macro, the cell number b2
Hello Dave,
Thanks for the below formulas.
The reason I am asking for the macro is that we have more then 25 sheet in a
file and more then 200 line items in each sheet, macro would help to reduce
the file size and minimize the changes of error.
I have attached a file in which i have tried to
Hi Joe,
The reason you get the flood of emails not solely pertaining to yourself is so
that perhaps you can help others with their problems, and not simply receive
solutions to your own. This is how the group works - everyone pitching in.
Regards - Dave.
From: j...@it4u.co.uk
To:
I want the chart to display only a portion of the data table with the
chart like this:
(only groups show in data table)
Instead of this:
(groups and control lines show)
It doesn't seem like changing the columns to white text is flowing
through to the data table that goes with the
Tom
I dont see an 'attach file' option when I reply..???
On Jan 8, 1:48 pm, Tom Jeffries tjeff...@gmail.com wrote:
When you reply to a message you will see an Attach File link beneath the To:
box.. Click it. You will then see a Choose File button. Click it. Select
file to be attached.
I think you can actually do this without a macro, but use Excel
formulas instead.
I have a calendar that for each quarter, I count the days that are
identified with
V for vacation day or H for Half day.
then, I use:
=COUNTIF($D6:$Z11,*H)*0.5+COUNTIF($D6:$Z11,*V)
to count the H's and V's.
In your
When you reply to a message you will see an Attach File link beneath the To:
box.. Click it. You will then see a Choose File button. Click it. Select
file to be attached. Click Open. That's all there is to it. The selected
file will be attached to your message.
On Thu, Jan 8, 2009 at 4:14 AM,
can you send the file.
Regards
CA. Atul Singhal
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: November 06, 2008 2:58 AM
To: MS Excel VBA Macros
Subject: $$Excel-Macros$$ Excel Macros totaling like values
How do I create a macro in Excel that will count
By using SUBTOTAL function in data menu, it can be done.
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Wed, 11/5/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
Thanks dude,
It worked wonderfully!!
Regards
Abhijit
_
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of SINGHAL, ATUL.
Sent: Thursday, October 23, 2008 2:36 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$
Hi
-Original Message-
*From:* Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED]
*Sent:* October 22, 2008 9:44 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Re: $$Excel-Macros$$
Hey guys,
Very interesting! I think most of the people have given RIGHT, MID
Type this formulae in C4
=right(b4,6)
and then drag down
Baloo
On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep
[EMAIL PROTECTED]wrote:
Dears..
How to copy particular data from one cell ? attached excel sheet for your
reference.
Thanks in advance
PRADEEP
Dear Pradeep
You may use the function, =RIGHT(B4,6).
I am enclosing the spreadsheet file sent by you.
Wish you all the Best.
N.Shivkumar
Office : +914027685423
Mobile : +919866533180
Res : +914040035774
Alternate Email : [EMAIL PROTECTED]
Dear Mr. Shivkumar
Thank you very much
Thanks and Regards
M. M. Pradeep mailto:[EMAIL PROTECTED]
From: N.Shivkumar [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2008 2:35 PM
To: excel-macros@googlegroups.com; Mattathil M. Pradeep
Subject: Re: $$Excel-Macros$$
Solution in the attached file.
On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep
[EMAIL PROTECTED]wrote:
Dears..
How to copy particular data from one cell ? attached excel sheet for your
reference.
Thanks in advance
PRADEEP
Hi Dude...
Yes it is there for that you need to install add in - --- Analysis
Tool pack
the FUNCTION name is =WEEKNUM(A1).
hope this will work..
Thanks,
yogesh
2008/9/18 Lakshmanan T S [EMAIL PROTECTED]
Hi friends,
Is there any predefined function or menu in
48 matches
Mail list logo