Dear NG,
I want to delete rows that contain #. I wrote a small macro for
this, which principally works, but always one row remains; it is
neither the first nor the last row and I have checked the macro
several time, but I don't find any mistake.
Here is the macro:
Dim z As Integer
Dim length
How I open xlsx file of 2007 in 2003
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further,
Here is the problem:
let's say you have 5 rows, and rows 3 and 4 have a #.
Anz_Zeilen then = 5.
Your look goes from 2 to 5.
when Zeile = 3,
the macro deletes row 3.
Now, what WAS row 4 becomes row 3.
the next loop changes Zeile to 4, thus skipping the CURRENT row 3.
when Zeile = 5, row 5 is
Hi Manoj,
You will need to save the Office 2007 file in compatibilty mode, ie save it in
the format of Excel97 to 2003. Then you will be able to open the file in MS
office 2003.
Thanks,
Amitabh
From: manoj...@ocimumbio.com
To: dilipan...@gmail.com;
Hi Manoj,
you need to download a small patch from MS website. Below is the URL for
that:
http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466displaylang=en
Regards
Vineet K.
2009/9/9 Manoj Kukrej manoj...@ocimumbio.com
How I open xlsx file of 2007 in
Dear Sathish Harmeet
Thanks for clarificaiton.
Regards.
On Wed, Sep 9, 2009 at 2:32 AM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi Prashant, Unfortunately, excel can show you first 100 unique entries
only in auto filter (It is hard coded in Excel)
Workaround can be pivot table.
Hi Friends,
Challenging request!!!
Need your help in solving a problem pertaining to Graphs in Excel.
*Refer attached sample Excel*
Sheet 1D6 I have given an option to select Call or Put in D6, Is there
any possibility, where we can select and display Call and Put simultaneously
on the same
Hello,
I have pated this link below, If you open this link there is some data
pasted in flash format, I was wondering if some one can help me copy the
Firm Names in Excel
http://www.law.com/jsp/tal/PubArticleTAL.jsp?id=1202430112194slreturn=1hbxlogin=1
Regards
Amit
Dear Manoj
For this, you have to download Microsoft Office Compatibility Pack from the
below link:
http://office.microsoft.com/en-us/products/HA101686761033.aspx
Yahya
On Wed, Sep 9, 2009 at 12:06 PM, Manoj Kukrej manoj...@ocimumbio.comwrote:
How I open xlsx file of 2007 in 2003
All,
This is just my thought but have no idea how to proceed. Can someone
please provide a solution, I will really appreciate.
Not sure how to attach a spreadsheet by my data spreadsheet is
uploaded to File section known as DATA.XLSX.
Col A. contains dates ( 1-Jan to 16-Aug ) and Col B-K
Dear All,
Its urgent,
i want to swap horizontal data into vertical data.
Range c6:j6,c7:j7,d8:j8..into vertical col d24: upto till all data
fetched.
Attached file is for ref..
--
-
A calm sea does not make a skilled sailor.
Wishing you and all your loved ones greatest of times
Thanks .. I learn something new every day!
On 7 Sep, 16:18, Norman May nor...@gmail.com wrote:
You can select the first sheet tab, hold the shift key then select the last
sheet tab.
This will activate all sheets.
Enter the desird content of the any cell
On Mon, Sep 7, 2009 at 5:53 AM,
Problem solved :-)
Thanks a lot!
On 9 Sep., 14:31, Paul Schreiner schreiner_p...@att.net wrote:
Here is the problem:
let's say you have 5 rows, and rows 3 and 4 have a #.
Anz_Zeilen then = 5.
Your look goes from 2 to 5.
when Zeile = 3,
the macro deletes row 3.
Now, what WAS row 4
It is just formating i.e. format cell i.e
Format/Cell/Number/Custom dd/mm/
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
hi
i m new to excel macro..i don't have an prior experience in
writing macros, honestly. i am preparing this excel sheet which will
act like my portfolio management tool (as i can't afford to buy any
software ! !)...so what i did i got my stock tickers / symbols
did run a web
I'm trying to troubleshoot this bit of sample code so that I can apply
the solution to my larger project.
On a worksheet I have a WorksheetChange event and a Selection_Change
event. What I am trying to do is capture the value of the new target
cell after the Selection_Change event.
This code
I think I've found the source of your problem.
it has to do with the line:
Set OldRange = Target
in this case, once you've issued this command,
OldRange will automatically update to whatever the
value of Target is.
the command doesn't HAVE to be reissued.
You have essentially ASSIGNED to
Hello Team,
Need ranking formula.See attached, kindly help.
Regards
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
Hi Ashish
Save your file as .xla (the last extension in 'save as type' box. When you
choose this extension the folder automatically changes to addins. Save the file
in this addins folder.
Then restrart the excel and from tools-Addins activate your addin and use it
as macro or function.
All you wise and mighty Excel gurus... I have the attached spreadsheet. I
will be scanning in the values (via a barcode scanner) into column A. What
I then need is a macro that will leave the Column A values in the order
that they appear, but then sort columns B,C and D to match the value in
use this formual, i think this should work
={SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrngE14,rankrng)),0))+1}
Use CTRL+SHIFT+ENTER after entering in the required cell instead of ENTER
Thanks
Ramesh
On Wed, Sep 9, 2009 at 9:58 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
Need ranking
-- Forwarded message --
From: Chanti ramesh1...@gmail.com
Date: Wed, Sep 9, 2009 at 11:08 PM
Subject: Re: $$Excel-Macros$$ Urgent_ Need ranking formula
To: excel-macros@googlegroups.com
use this formual, i think this should work
{=SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrngE14,rankrng)),0))+1}
I think this formula should work for you..
Thanks,
Ramesh
On 9 Sep, 21:28, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
Need ranking formula.See attached, kindly help.
Regards
Text.xls
18KViewDownload
Enter the following array formula in cell G14 then copy it down to G22:
=RANK(E14,$E$14:$E$22,0)-SUM(IF(FREQUENCY($E$14:$E$22,$E$14:$E$22)0,0,1)*IF($E$14:$E$23E14,1,0))
This formula must be entered as an array formula using (Ctrl + Shift +
Enter).
This formula came from the website below:
Any ideas on why I get this error with the macro below?
Sub Headers_To_Macro_Test()
' Headers_To_MAcro_Test Macro
' Macro recorded 9/9/2009 by
Dim wksCopy As Worksheet
Dim wksPaste As Worksheet
Dim rngCopy As Range
Dim rngPaste As Range
With ThisWorkbook
Set wksCopy = .Worksheets(Summary)
Set
*See attached file*
On Wed, Sep 9, 2009 at 11:08 PM, rad...@progressivetel.com
rad...@progressivetel.com wrote:
All you wise and mighty Excel gurus... I have the attached spreadsheet. I
will be scanning in the values (via a barcode scanner) into column A. What
I then need is a macro
Hi LD
The macro is corrected below. I removed the function
SetPasteRangebyColumn, since it was of no use and implemented
incorrectly. Since, in this function you're not setting the function's
return value - so it is set to Nothing, by default.
This is the range that when you paste the range, it
Hi Ron,
Please login using ur palas...@gmail.com id. and attach your file in
the mail and then finally, send this mail to excel-
mac...@googlegroups.com and 26may.1...@gmail.com
--
Thanks Regards
Ashish Jain
(Excel Macros
A solution is attached.
Just insert another column where you calculate the Puts - you can hide this
column like you did with column B if you don't want to see it displayed.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Chanti
Sent: Wednesday, 9
i would like to know how can i compare 2 (A B)cols in sheet 1 to
another 2(C D) cols in sheet 2 AND tells me in sheet2 (col E)
That the values from sheet1 col A match sheet2 col C. If it matches,
it will continue to match sheet 1 colB with sheet 2 colD. If the above
matches, it will tell me in
Hi Excel Guru,
I want to import data from excel to Quickbooks (Accounting Software) and need
help in this regards. If you have information please send it to me.
Regards,
_
Share your memories online with anyone
31 matches
Mail list logo