I will once again explain my query.
I have a table which contains data relating to about 100 schemes for 2500
dealers in the following format
DEALER CODE
DEALER NAME
RDS NAME
SCH-1
SCH-2
SCH-100
TOTAL EARNING
1
A
AA
100
90
190
2
B
BB
150
85
17
252
3
C
AA
200
$uperb sam... Really ur great.
Thank you and regards
Yogananda Muthaiah
On 1/14/12, Sam Mathai Chacko wrote:
> Set objExcel = CreateObject("Excel.Application")
> Set objWorkbook =
> objExcel.Workbooks.Open("C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls")
> for each wks in objworkbook.wo
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook =
objExcel.Workbooks.Open("C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls")
for each wks in objworkbook.worksheets
wks.Range("A2", wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete
next
objWorkbook.Save '"C:\User
2012/1/13 Rajan_Verma
> Hi
>
> Please explain what kind of invoice management application are you looking
> for.. what will that do?
>
> ** **
>
> ** **
>
> Rajan.
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amresh Maurya
> *Sent
Hi sam
As you provided in excel vba .. I would need the same to run through vb script.
keep 1 xl in desktop with records which we need *.vbs
to run delete rows from range A2 to till end in xl
On 1/14/12, Sam Mathai Chacko wrote:
> Try in vb script? I have no idea what you are trying to convey.
>
Yes! Works!
Thank you very, very much.
De: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Em
nome de Sam Mathai Chacko
Enviada em: sábado, 14 de janeiro de 2012 02:26
Para: excel-macros@googlegroups.com
Assunto: Re: $$Excel-Macros$$ Form to datasheet
Try this, Cel
2012/1/13 NOORAIN ANSARI
> Dear Satvik,
>
> One of my friend provided me below link to prepare MIS Resume..
> Hope it may help to you..
>
>
> http://career-resources.dice.com/technical-resume/sample_resumes/vba_developer.shtml
>
>
>
> On Fri, Jan 13, 2012 at 10:27 PM, Satvik wrote:
>
>> **
>> So
Hi Santosh,
yes it is possible, please find the attachment
On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Group,
>
> Is it possible to show a statement moving from right to left in MS Excel
> that we usually see in websites or in our system screen
Try in vb script? I have no idea what you are trying to convey.
On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:
> Thank you sam
> Can you please try in vb script on same
>
> On 1/14/12, Sam Mathai Chacko wrote:
> > Sub DelRows()
> >
> > Dim wks
Thank you sam
Can you please try in vb script on same
On 1/14/12, Sam Mathai Chacko wrote:
> Sub DelRows()
>
> Dim wks As Worksheet
>
> For Each wks In ThisWorkbook.Worksheets
> With wks
> .Range("A2",
> .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Del
Sumproduct should work as well withOUT array entering
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Maries
Sent: Saturday, January 14, 2012 5:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help
Find the attached file...
On Sat, Jan 14, 2012 at 11:08 AM, Sa
Thanx
From: Maries
To: excel-macros@googlegroups.com
Sent: Saturday, 14 January 2012 5:51 PM
Subject: Re: $$Excel-Macros$$ Delete text only
Use below code:
Sub OnlyNumric()
Dim rng As Range
Set rng = Range("Sheet1!A1:A1000")
For i = 1 To 1000
With
*Use below code:
*
Sub OnlyNumric()
Dim rng As Range
Set rng = Range("Sheet1!A1:A1000")
For i = 1 To 1000
With rng
If IsNumeric(rng.Cells(i, 1).Value) Then
.Cells(i, 4).Value = .Cells(i, 1).Value
End If
End With
Next i
End Sub*
*
Regards,
Hi Group,
Is it possible to show a statement moving from right to left in MS Excel
that we usually see in websites or in our system screen savers.
If yes please help me with this.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1)
*Find the attached file...*
On Sat, Jan 14, 2012 at 11:08 AM, Sam Mathai Chacko wrote:
> You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it
> will work in Excel 2003 or 2007+
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA
> wrote:
>
Dear Noorain,
it, ok
but if i want to remove number/disite?
Regards
LAKSHMAN
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Friday, 13 January 2012 8:25 PM
Subject: Re: $$Excel-Macros$$ Delete text only
Dear Lokesh,
Please try it..
Sub
16 matches
Mail list logo
