sorry
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Harmeet Singh
Sent: Thursday, March 26, 2009 7:20 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Convert PDF to Excel (-PIN-)
Hi All Intelligent people out there.
I have a excel table as below
Xxx 1 5
Yyy Fgf Dfd
Zzz dfg Dsgf
qqq 4 fg dfg
i need to get all the values of occupied cells in every row...
so in the 1st row...i need to get the values
xxx
1 and 5 excluding space in 3rd column
Hi Members,
I recently noticed a MVP active in our group and would like to bring
him in your notice. He is *Mr. Rodney Powell*, Microsoft's certified
Most Valuable Professional.
Let's welcome him with great heart and tons of applause for his deep
commitment shown in past years to the real world
Hello Everyone
This is my first query. I am consolidating my stocks balance sheet for
the fiscal year 2008-09.
I am having 2 columns.
A B
Reliance Sell
ABB Buy
RNRL Sell
Reliance Buy
ABB Sell
RNRL
Praveen --
If you must use VBA, you can adapt some variation of the following
procedure ...
Sub Reliance_Buy()
Dim r, LastRow, Cnt
With Sheet1
LastRow = 9
For r = 1 To LastRow
If .Cells(r, 1).Value = Reliance And _
.Cells(r, 2).Value = Buy Then _