RE: $$Excel-Macros$$ Re: Request for support for a looping macro

[Asa Rossoff]

Hi David,
True.  The worksheet as posted had no formulas, but it is worth trying and
would likely be beneficial if the macro will be used on a sheet with
formulas.
The "fast" version of the function probably only has 4 lines of VBA that
could trigger calculation(one shifts the values with a range.value2
assignment, one clears a group of cells, the third inserts a group of rows,
and the fourth places text in a cell of each of the newly inserted rows),
which might mean that only 4 recalculations could be triggered (though I'm
not sure on that).
The simpler function takes action on each record/group of cells individually
in a loop, and would likely benefit greatly from disabling calculation if
there are formulas.
Cheers,
Asa


-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of David Grugeon
Sent: Saturday, October 20, 2012 5:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Request for support for a looping macro

I wonder if it would speed it up if you set calculation to xlmanual?


Regards
David Grugeon


On 21 October 2012 03:23, Asa Rossoff  wrote:
> Hi Diamond Dave,
>
> I started out planning to give you a few general thoughts just based on
your
> email, without having seen the workbook.  I typed out more than a few in
the
> end, and then thought, if that was worth the time, it's surely worth the
> time to find your old message, open your attachment and actually take a
> look.
>
>
>
> When I took a look, I found that none of my typed examples, although I
hoped
> would be generally educational, would get you all the way to a solution.
So
> I worked up a working rewrite of your routine for you.  I will list that
> first.
>
>
>
> This working version doesn't use A1 for the number of shifts to perform.
It
> calculates the same for display purposes (status bar), but in fact it
works
> its way down the sheet using the equivalent of Ctrl-DownArrow --
> RANGE.End(xlDown) -- and processes each dataset/record that it finds and
> that needs shifting (it won't shift ones that have already been shifted).
>
>
>
> See attached file or download the same: Fast Shifting of disparate
> ranges-for Diamond (asa).xls
>
> https://docs.google.com/open?id=0Bwkcc6g0MuPTUWZFQTE1RG1mZ1k
>
>
>
> Although this macro looks much different from yours, the effect is
> essentially the same. cut and paste each dataset:
>
> Sub asaShiftData()
>
> Dim Worksheet As Worksheet
>
> Dim DataSet As Range, TopLeft As Range
>
> Dim Rows As Long, Counter As Long, Counter2 As Long, Total As Long
>
> Dim Status As String
>
> Set Worksheet = ThisWorkbook.Worksheets("Header")
>
> Set TopLeft = Worksheet.Range("E1").End(xlDown).End(xlDown)
>
> Application.ScreenUpdating = False
>
> Total = WorksheetFunction.CountA(Worksheet.Range("B:B")) - 1
>
> Do While TopLeft.Value <> ""
>
> Counter2 = Counter2 + 1
>
> If Counter2 Mod 10 = 0 Then DoEvents
>
> Set DataSet = Worksheet.Range(TopLeft,
> TopLeft.End(xlToRight).End(xlDown))
>
> If TopLeft.Offset(, -1).Value = "" Then
>
> Counter = Counter + 1
>
> DataSet.Cut Destination:=DataSet.Offset(, -1)
>
> Rows = DataSet.Rows.Count
>
> TopLeft.Offset(Rows).EntireRow.Insert
>
> TopLeft.Offset(Rows).Value = "Variance"
>
> Set TopLeft = TopLeft.Offset(, 1)
>
> End If
>
> Set TopLeft = TopLeft.End(xlDown).End(xlDown).End(xlDown)
>
> GoSub GetStatus
>
> Application.StatusBar = Status
>
> Loop
>
> Application.ScreenUpdating = True
>
> Application.StatusBar = False
>
> MsgBox Status
>
> Exit Sub
>
> GetStatus:
>
> Status = "Shifted " & Counter & " of " & Counter2 & "(" & Total & ")
> production lines.  " & Int(Counter2 / Total * 100) & "% complete."
>
> Return
>
> End Sub
>
>
>
> After testing the above macro with about 1,000 datasets to shift, I was
> concerned about the time it took: about 5.5 minutes.  So I worked up a
more
> efficient, but more complex version that did the same in 58 seconds.  It
has
> a few limitations, mentioned in comments in the code, but is suitable for
> most purposes:
>
> Sub asaShiftDataFast()
>
> Dim Worksheet As Worksheet
>
> Dim SourceRange As Range, InsertRange As Range, Cells As Range
>
> Dim DestinationRange As Range, DestCell1 As Range
>
> Dim SrcCol As Range, SrcCell As Range
>
> Dim TopLeft As Range, FirstColumn As Range
>
> Dim ColIdx As Long, ColLeftIdx As Long, ColRightIdx As Long
>
> Dim RowIdx As Long, RowCount As Long
>
> Dim Total As Long
>
> Dim SrcFont As Font, DestFont1 As Font
>
> Dim Abort As Boolean
>
> Set Worksheet = ThisWorkbook.Worksheets("Header")
>
> Set TopLeft = Worksheet.Range("E1").End(xlDown)
>
> Set FirstColumn = TopLeft.EntireColumn
>
> Total = WorksheetFunction.CountA(Worksheet.Range("B:B")) - 1
>
>
>
> Application.ScreenUpdating = False
>
>
>
> 'Find rows that need shifting

Re: $$Excel-Macros$$ Re: Request for support for a looping macro

[David Grugeon]

I wonder if it would speed it up if you set calculation to xlmanual?


Regards
David Grugeon


On 21 October 2012 03:23, Asa Rossoff  wrote:
> Hi Diamond Dave,
>
> I started out planning to give you a few general thoughts just based on your
> email, without having seen the workbook.  I typed out more than a few in the
> end, and then thought, if that was worth the time, it's surely worth the
> time to find your old message, open your attachment and actually take a
> look…
>
>
>
> When I took a look, I found that none of my typed examples, although I hoped
> would be generally educational, would get you all the way to a solution.  So
> I worked up a working rewrite of your routine for you.  I will list that
> first.
>
>
>
> This working version doesn't use A1 for the number of shifts to perform.  It
> calculates the same for display purposes (status bar), but in fact it works
> its way down the sheet using the equivalent of Ctrl-DownArrow --
> RANGE.End(xlDown) -- and processes each dataset/record that it finds and
> that needs shifting (it won't shift ones that have already been shifted).
>
>
>
> See attached file or download the same: Fast Shifting of disparate
> ranges-for Diamond (asa).xls
>
> https://docs.google.com/open?id=0Bwkcc6g0MuPTUWZFQTE1RG1mZ1k
>
>
>
> Although this macro looks much different from yours, the effect is
> essentially the same… cut and paste each dataset:
>
> Sub asaShiftData()
>
> Dim Worksheet As Worksheet
>
> Dim DataSet As Range, TopLeft As Range
>
> Dim Rows As Long, Counter As Long, Counter2 As Long, Total As Long
>
> Dim Status As String
>
> Set Worksheet = ThisWorkbook.Worksheets("Header")
>
> Set TopLeft = Worksheet.Range("E1").End(xlDown).End(xlDown)
>
> Application.ScreenUpdating = False
>
> Total = WorksheetFunction.CountA(Worksheet.Range("B:B")) - 1
>
> Do While TopLeft.Value <> ""
>
> Counter2 = Counter2 + 1
>
> If Counter2 Mod 10 = 0 Then DoEvents
>
> Set DataSet = Worksheet.Range(TopLeft,
> TopLeft.End(xlToRight).End(xlDown))
>
> If TopLeft.Offset(, -1).Value = "" Then
>
> Counter = Counter + 1
>
> DataSet.Cut Destination:=DataSet.Offset(, -1)
>
> Rows = DataSet.Rows.Count
>
> TopLeft.Offset(Rows).EntireRow.Insert
>
> TopLeft.Offset(Rows).Value = "Variance"
>
> Set TopLeft = TopLeft.Offset(, 1)
>
> End If
>
> Set TopLeft = TopLeft.End(xlDown).End(xlDown).End(xlDown)
>
> GoSub GetStatus
>
> Application.StatusBar = Status
>
> Loop
>
> Application.ScreenUpdating = True
>
> Application.StatusBar = False
>
> MsgBox Status
>
> Exit Sub
>
> GetStatus:
>
> Status = "Shifted " & Counter & " of " & Counter2 & "(" & Total & ")
> production lines.  " & Int(Counter2 / Total * 100) & "% complete."
>
> Return
>
> End Sub
>
>
>
> After testing the above macro with about 1,000 datasets to shift, I was
> concerned about the time it took: about 5.5 minutes.  So I worked up a more
> efficient, but more complex version that did the same in 58 seconds.  It has
> a few limitations, mentioned in comments in the code, but is suitable for
> most purposes:
>
> Sub asaShiftDataFast()
>
> Dim Worksheet As Worksheet
>
> Dim SourceRange As Range, InsertRange As Range, Cells As Range
>
> Dim DestinationRange As Range, DestCell1 As Range
>
> Dim SrcCol As Range, SrcCell As Range
>
> Dim TopLeft As Range, FirstColumn As Range
>
> Dim ColIdx As Long, ColLeftIdx As Long, ColRightIdx As Long
>
> Dim RowIdx As Long, RowCount As Long
>
> Dim Total As Long
>
> Dim SrcFont As Font, DestFont1 As Font
>
> Dim Abort As Boolean
>
> Set Worksheet = ThisWorkbook.Worksheets("Header")
>
> Set TopLeft = Worksheet.Range("E1").End(xlDown)
>
> Set FirstColumn = TopLeft.EntireColumn
>
> Total = WorksheetFunction.CountA(Worksheet.Range("B:B")) - 1
>
>
>
> Application.ScreenUpdating = False
>
>
>
> 'Find rows that need shifting
>
> 'This approach is limited to 8,192 product lines
>
> '  (areas in the range) in Excel versions < Excel 2010.
>
> Application.StatusBar = "Identifying records that need shifting..."
>
> On Error Resume Next ' specialcells generates error if no cells
>
> Set SourceRange = FirstColumn.SpecialCells(xlCellTypeFormulas)
>
> If SourceRange Is Nothing Then
>
> Err.Clear
>
> Set SourceRange = FirstColumn.SpecialCells(xlCellTypeConstants)
>
> Else
>
> Set SourceRange = Union(SourceRange,
> FirstColumn.SpecialCells(xlCellTypeConstants))
>
> End If
>
> Set SourceRange = SourceRange.Offset(,
> -1).SpecialCells(xlCellTypeBlanks)
>
> Abort = Err.Number <> 0 'nothing to shift...
>
> If Not Abort Then
>
> Set SourceRange = SourceRange.Offset(,
> -2).SpecialCells(xlCellTypeBlanks)
>
> Abort = Err.Number <> 0 'nothing to shift...
>
> On Error GoTo 0 ' stop ignoring errors
>
> If Not Abort Then
>
> Set

Re: $$Excel-Macros$$ Abc in a column

[David Grugeon]

In each cell put =CHAR(ROW()+64))  If the list doesn't start in row 1
you will need to decrease the 64 accordingly

Regards

David Grugeon


On 21 October 2012 02:35, Manoj Kumar  wrote:
> Hi expert
>
> I want ABC in a  column. So can u help me on this. In a  column ABC from a
> to z.
>
> Thanks
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Sending chart in mail.

[Vignesh S R]

hi ,
i have generated chart using macro.
the thing is,i have to extract the chart alone and send it using mail to
other id using excel macro(mail also should be created)

Kindly  help .

-- 
Vignesh .S.R

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Chat_1.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Abc in a column

[ashish koul]

type this in a1 and drag it right till column Z

=MID(ADDRESS(1,COLUMN(A2)),2,LEN(ADDRESS(1,COLUMN(A2)))-3)



On Sat, Oct 20, 2012 at 10:05 PM, Manoj Kumar wrote:

> Hi expert
>
> I want ABC in a  column. So can u help me on this. In a  column ABC from a
> to z.
>
> Thanks
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Abc in a column

[Manoj Kumar]

Hi expert

I want ABC in a  column. So can u help me on this. In a  column ABC from a
to z.

Thanks
Manoj

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Excel Graph Problem

[prkhan56]

Reposting - any help on this please?
Regards

On Wednesday, October 17, 2012 10:20:15 PM UTC+4, prkhan56 wrote:

> Hello there,
> Thanks for the reply
> Can you guide me how to setup my data please?
> Regards
> Rashid Khan
> On Tuesday, October 16, 2012 9:31:53 PM UTC+4, Sushil Kumar wrote:
>
>> Hi Rashid,
>> Your graph not correct
>> and graph looks the image of waterfall chat so you need to setup the 
>> cross of x-axes and y-axes bar
>> then according to data your chart move up and down or cross the axes
>>
>>
>> On Tue, Oct 16, 2012 at 10:57 PM, Rashid Khan  wrote:
>>
>>> Hello All,
>>> Is it possible to create the graph shown on the attached file as per the 
>>> data shown?
>>>  
>>> Regards
>>> Rashid Khan
>>>
>>> -- 
>>> Join official facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>  
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>>  
>>> 2) Don't post a question in the thread of another member.
>>>  
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>>  
>>> 4) Acknowledge the responses you receive, good or bad.
>>>  
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>>> signatures are prohibited. 
>>>  
>>> 6) Jobs posting is not allowed.
>>>  
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>  
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to 
>>> excel-macros...@googlegroups.com.
>>>  
>>>  
>>>
>>
>>
>>
>> -- 
>> *Sushil Sharma*   / CEO / Smart Solutions
>>
>> _
>> Mobile: +919029029072 
>> 102, B-20, Sector-1, Mira Road, Mumbai, India
>> email: sushil.sha...@smalution.com 
>> skype:smalution
>> web:   http://www.smalution.com 
>> http://www.linkedin.com/pub/sushil-sharma/30/98b/578
>>  
>>
>>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Excel VBA Query

[ashish koul]

Add a new blank column before A in both the workbooks and use below formula
in cell a2 and fill it down

IF(B2<>"",B2&C2,LEFT(A1,FIND(C1,A1))&C2)


then use simple vlookup to get the status

Regards
Ashish





On Sat, Oct 20, 2012 at 6:14 PM, Manish Bankoti
wrote:

> Hi,
>
>  Please find attached two files - Input and Output...Need to fill "Follow
> up" column with the help of input file with the help of VBA...Matching
> countries and sub countries both..It can have duplicate sub countries so it
> both A and B columns should be matched...Need on urgent basis, please reply.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Good Laptop to Buy..

[vba]

Hi, 

Thanks Joseph.

Rgds//Vabs
Sent on my BlackBerry® from Vodafone

-Original Message-
From: joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 14:00:52 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..

Either Dell or Lenovo


Sent on my BlackBerry® from Vodafone

-Original Message-
From: v...@vabs.in
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 12:30:29 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..

Hi Emerson

Can you pl suggest name of co. ?

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Emerson Informática 
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 09:28:07 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..

Its good.


2012/10/20 

> Hi,
>
> All I want to buy good laptop for my personal use, pl experts suggest on
> it.
>
> Min. Configuration required:
>
> 4GB Ram, Intel I5, 1TB HD..
>
> It should be value for money also..
>
> Which company to go for ..
>
> Thanks a lot..
>
> Cheers//Vabs
>
> Sent on my BlackBerry® from Vodafone
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
*Emerson da Silva Cardozo*
Informática - (11) 9778-8920vivo

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 

Re: $$Excel-Macros$$ Good Laptop to Buy..

[joseph . camill]

Either Dell or Lenovo


Sent on my BlackBerry® from Vodafone

-Original Message-
From: v...@vabs.in
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 12:30:29 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..

Hi Emerson

Can you pl suggest name of co. ?

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Emerson Informática 
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 09:28:07 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..

Its good.


2012/10/20 

> Hi,
>
> All I want to buy good laptop for my personal use, pl experts suggest on
> it.
>
> Min. Configuration required:
>
> 4GB Ram, Intel I5, 1TB HD..
>
> It should be value for money also..
>
> Which company to go for ..
>
> Thanks a lot..
>
> Cheers//Vabs
>
> Sent on my BlackBerry® from Vodafone
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
*Emerson da Silva Cardozo*
Informática - (11) 9778-8920vivo

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses y

Re: $$Excel-Macros$$ Good Laptop to Buy..

[vba]

Hi Emerson

Can you pl suggest name of co. ?

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Emerson Informática 
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 09:28:07 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..

Its good.


2012/10/20 

> Hi,
>
> All I want to buy good laptop for my personal use, pl experts suggest on
> it.
>
> Min. Configuration required:
>
> 4GB Ram, Intel I5, 1TB HD..
>
> It should be value for money also..
>
> Which company to go for ..
>
> Thanks a lot..
>
> Cheers//Vabs
>
> Sent on my BlackBerry® from Vodafone
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
*Emerson da Silva Cardozo*
Informática - (11) 9778-8920vivo

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Good Laptop to Buy..

[Emerson Informática]

Its good.


2012/10/20 

> Hi,
>
> All I want to buy good laptop for my personal use, pl experts suggest on
> it.
>
> Min. Configuration required:
>
> 4GB Ram, Intel I5, 1TB HD..
>
> It should be value for money also..
>
> Which company to go for ..
>
> Thanks a lot..
>
> Cheers//Vabs
>
> Sent on my BlackBerry® from Vodafone
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
*Emerson da Silva Cardozo*
Informática - (11) 9778-8920vivo

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Good Laptop to Buy..

[vba]

Hi,

All I want to buy good laptop for my personal use, pl experts suggest on it.

Min. Configuration required:

4GB Ram, Intel I5, 1TB HD..

It should be value for money also..

Which company to go for ..

Thanks a lot..

Cheers//Vabs

Sent on my BlackBerry® from Vodafone

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

[vba]

Hi

Download this extension and Install.

www.microsoft.com/en-us/download/details.aspx?id=7

Rgds//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Constantin Zamfir 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 20:58:18 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help me to set default folder for print 
PDF's.

Yes, but in the combobox "Save as type:" I don't have PDF format.

Best regards,
*Constantin ZAMFIR*
Service engineer,
Euritmic Grup SRL  - Romania
Mobil: +40 741-105-012  (Orange)
Mobil: +40 726-226-021  (Cosmote)
*Before printing this e-mail please consider environment protection*
*
---
*
*
*



2012/10/19 

> **
> Hi,
>
> Insted of printing with the help of Nitro PDF you can save file as PDF.
>
> Rgds//Vabs
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Constantin Zamfir 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT)
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Please help me to set default folder for
> print PDF's.
>
> I have a macro in an Excel document that print 5 sheets in different
> folders with different names. Always have to navigate to the desired folder
> and write the desired name, which slows my work, since I'm doing this for
> 30-50 times per day.
> I want to automate this in my macro, but I do not know how to change the
> default print folder for NitroPDF 7 and the default name for the file to be
> printed.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this m

Re: $$Excel-Macros$$ Change all the destination cell

[vba]

Hi

Try this type in cell A1

=indirect(''Sheet1!'&B1&row())

And in B1 type E

Now Drag Down..

Cheerz//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 11:12:54 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change all the destination cell

Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like 
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I want the destination column of entire linked column to be changed to e 
like
'Sheet1!e5
'Sheet1!e6
'Sheet1!e7
'Sheet1!e8
'Sheet1!e9so on.

Please help to change all this in one function.

Sandeep Chhajer.

'Sheet1!e5
Sent on my BlackBerry® from Vodafone

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Send Email with for Selected range

[vba]

Hi

Go to this site for help:

www.rondebruin.nl/sendmail.htm

You will get lots of info there.

Rgds//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Rahim Sharieff 
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 16:13:51 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Send Email with for Selected range

Hello all,

I need a macro to send email using excel with the Selected range of data.

Refer the attachment for more details:
1. We have a number of customers.
2. And we have a number of products of each customer.
3. I want to send to a Customer all its Products, Amount & Date using the
email address provided in the column "G"

Thanks.
RS

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Change all the destination cell

[vba]

Hi

Use indirect function.

Rgds//vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 11:12:54 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change all the destination cell

Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like 
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I want the destination column of entire linked column to be changed to e 
like
'Sheet1!e5
'Sheet1!e6
'Sheet1!e7
'Sheet1!e8
'Sheet1!e9so on.

Please help to change all this in one function.

Sandeep Chhajer.

'Sheet1!e5
Sent on my BlackBerry® from Vodafone

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Change all the destination cell

[chhajersandeep]

Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like 
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I want the destination column of entire linked column to be changed to e 
like
'Sheet1!e5
'Sheet1!e6
'Sheet1!e7
'Sheet1!e8
'Sheet1!e9so on.

Please help to change all this in one function.

Sandeep Chhajer.

'Sheet1!e5
Sent on my BlackBerry® from Vodafone

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Send Email with for Selected range

[Rahim Sharieff]

Hello all,

I need a macro to send email using excel with the Selected range of data.

Refer the attachment for more details:
1. We have a number of customers.
2. And we have a number of products of each customer.
3. I want to send to a Customer all its Products, Amount & Date using the
email address provided in the column "G"

Thanks.
RS

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Send Email.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Required help: Any Solution to import text from Scanned Documents

[Kuldeep Singh]

http://www.onlineocr.net/

Regards,
Kuldeep Singh

On Sat, Oct 20, 2012 at 3:37 PM, rashid memon wrote:

> Dear Experts,
>
> i want to import text data from scanned documents (JPG format) please help
> me if there is any solution for it.
>
>
> Thanks & Best Regards
>
> M. Rashid
>
> Email:- *mr.rashidme...@gmail.com*
> Cell: 0323-3289198
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Required help: Any Solution to import text from Scanned Documents

[rashid memon]

Dear Experts,

i want to import text data from scanned documents (JPG format) please help
me if there is any solution for it.


Thanks & Best Regards

M. Rashid

Email:- *mr.rashidme...@gmail.com*
Cell: 0323-3289198

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Solve the problem

[Aamir Shahzad]

PFA

Aamir Shahzad

On Sat, Oct 20, 2012 at 1:29 PM, Rajan_Verma wrote:

> *You can use NetworkDays.INTL()  parameters are same as previous *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rajeyssh
> *Sent:* 20 October 2012 1:31
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Solve the problem
>
>
>
> Thanks Sir and If I want to calculate on 6days week format how Can I do it.
>
> rajesh
>
>
> On Wednesday, October 17, 2012 6:51:47 PM UTC+5:30, Rajan_Verma wrote:
>
> *Is it you are looking for?*
>
> * *
>
> *=NETWORKDAYS(A2,A2+25,$E$2:$E$17)*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On
> Behalf Of *Rajesh Agarwal
> *Sent:* 17 October 2012 3:46
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Solve the problem
>
>
>
> Dear Sir
>
> I want to put formula on column B.
>
> Rgds
>
>
>
> --
> *Rajesh Kumar Agarwal*
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 

Regards,
Aamir Shahzad

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, For

RE: $$Excel-Macros$$

[Rajan_Verma]

 

Here are a simplest example,

 

You can use this code to understand the thing about screen updating
True/False

 

ScreenUpdating is Application Property , so it works on application level,
means once it set to False then it will be false for every procedure until
it is not set to TRUE,

Try to execute below procedure after and before commenting Third Last Line J

 

Sub FillByloop()

Dim lngI As Long

Application.ScreenUpdating = False

For lngI = 1 To 1

[a1] = lngI

Next

Application.ScreenUpdating = True

Call FillByloop2

End Sub

 

 

Sub FillByloop2()

Dim lngI As Long

For lngI = 1 To 1

[a1] = lngI

Next 

End Sub

 

===

Enjoy J

===

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 20 October 2012 12:01
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$

 

Thanks to all

Just one question for Knowledge

I run the script by both way

1.By Making true at the end

2.Without making true at end

I could not notice any difference.

So please can any one explain me  

What is the purpose of making true at end?

Aging I ma repeating this is just for Knowledge.

 

Regards

Shrinivas

On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma 
wrote:

But also make them TRUE at end of code 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 19 October 2012 5:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$

 

Dear Both,

 

Very very thanks for solution.

 

Regards

Shrinivas

On Fri, Oct 19, 2012 at 1:19 PM,  wrote:

Hi

Just put Application.Screenupdating = False

Rgds// Vabs 

 

Sent on my BlackBerryR from Vodafone

  _  

From: Shrinivas Shevde  

Sender: excel-macros@googlegroups.com 

Date: Fri, 19 Oct 2012 12:29:55 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$

 

Dear Group member,

 

I wrote small macro which works fine.

But when I run macro it shows all action i.e everything ishappening in front
of user which I dont want .

I want that when I run macro Worksheet should be steady and all actions
should happen at backend.

How to do it please let me know.

Is ther any extra code needs to write.

-- 
Shrini

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 




-- 
Shrini

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (11

RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

[Daniel]

Thanks a lot. It works.

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Rajan_Verma
Envoyé : samedi 20 octobre 2012 06:31
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

 

 

Try this 

ActiveChart.ChartArea.Format.Fill.GradientStops.Insert(RGB)

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: 20 October 2012 12:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

 

Hello, all,

 

Someone asks me if it were possible to format a chart area with a gradient
fill of more than two colors. I can’t find no clue to this one.

Can anyone help ?

TIA

 

Daniel

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Solve the problem

[Rajan_Verma]

You can use NetworkDays.INTL()  parameters are same as previous 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rajeyssh
Sent: 20 October 2012 1:31
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Solve the problem

 

Thanks Sir and If I want to calculate on 6days week format how Can I do it.

rajesh


On Wednesday, October 17, 2012 6:51:47 PM UTC+5:30, Rajan_Verma wrote:

Is it you are looking for?

 

=NETWORKDAYS(A2,A2+25,$E$2:$E$17)

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-...@googlegroups.com 
[mailto:excel-...@googlegroups.com  ] On Behalf Of Rajesh
Agarwal
Sent: 17 October 2012 3:46
To: excel-...@googlegroups.com  
Subject: $$Excel-Macros$$ Solve the problem

 

Dear Sir

I want to put formula on column B.

Rgds


 

-- 
Rajesh Kumar Agarwal

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-...@googlegroups.com
 .
To unsubscribe from this group, send email to
excel-macros...@googlegroups.com  .
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ VBA enabled sheet doesn't allow to protect

[ashish koul]

can u share the file and password of sheet



On Sat, Oct 20, 2012 at 1:36 PM, Pravin Gunjal  wrote:

> *Hi Rajan*
> *
> *
> *Pl let me know where it should be given.  As I have tried but it's not
> working.*
> *And my excel sheet name is : "Field Emails"*
> *
> *
> *Please do the needful.*
> *
> *
> *Thanks,*
> *Pravin Gunjal.
> *
>
> -- Forwarded message --
> From: Rajan_Verma 
> Date: Sat, Oct 20, 2012 at 12:02 PM
> Subject: RE: $$Excel-Macros$$ VBA enabled sheet doesn't allow to protect
> To: excel-macros@googlegroups.com
>
>
> *Sub DoSomething()*
>
> * *
>
> *Sheet1.Unprotect Pwd*
>
> *‘Your code goes here*
>
> *Sheet1.Protect Pwd*
>
> * *
>
> *End sub*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
> *Sent:* 20 October 2012 11:58
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ VBA enabled sheet doesn't allow to protect
>
> ** **
>
> *Dear Friends,*
>
> ** **
>
> *I have an Macro / VBA enabled file with me.  If I protect the sheet
> which has a VBA code, then macro doesn't work and displays the following
> error.  Kindly get the solution on it topic.  Thank you.*
>
> ** **
>
> *[image: Inline image 1]*
>
> ** **
>
> *Regards*
>
> *Pravin Gunjal.*
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

Re: $$Excel-Macros$$ Formula to obtain the same record from the above line

[ashish koul]

j3 =IF(AND(E3=E2,F3=F2,G3=G2),"True","False")

and drag it down





On Sat, Oct 20, 2012 at 1:30 PM, Pravin Gunjal  wrote:

> *Hello Friends,*
>
> * *
>
> *I need a formula which can be find out the same record of the above
> line, if correct then it says “TURE” otherwise “FALSE”  (all the four
> column should match with above records).  Please help me to get the same.
> thank you.*
>
> *
> *
>
> *The file is attached for your reference.*
>
> *
> *
>
> *Regards*
>
> *Pravin Gunjal*
>
> *
> *
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Solve the problem

[rajeyssh]

Thanks Sir and If I want to calculate on 6days week format how Can I do it.
rajesh

On Wednesday, October 17, 2012 6:51:47 PM UTC+5:30, Rajan_Verma wrote:
>
> *Is it you are looking for?*
>
> * *
>
> *=NETWORKDAYS(A2,A2+25,$E$2:$E$17)*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Rajesh Agarwal
> *Sent:* 17 October 2012 3:46
> *To:* excel-...@googlegroups.com 
> *Subject:* $$Excel-Macros$$ Solve the problem
>
>  
>
> Dear Sir
>
> I want to put formula on column B.
>
> Rgds
>
>  
>
> -- 
> *Rajesh Kumar Agarwal*
>
>  
>
> -- 
> Join official facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES (1120+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> 6) Jobs posting is not allowed.
>  
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com .
>  
>  
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Solve the problem

[rajeyssh]

Thanks Sir and If I want to calculate on 6days week format how Can I do it.
rajesh

On Wednesday, October 17, 2012 4:55:33 PM UTC+5:30, Aamir Shahzad wrote:
>
> PFA
>
> Aamir Shahzad
> On Wed, Oct 17, 2012 at 3:16 PM, Rajesh Agarwal 
> 
> > wrote:
>
>> Dear Sir 
>> I want to put formula on column B.
>> Rgds
>>
>> -- 
>> *Rajesh Kumar Agarwal* 
>>
>> -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> 6) Jobs posting is not allowed.
>>  
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>>  
>>  
>>
>
>
>
> -- 
>  
> Regards,
> Aamir Shahzad
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ help:increase the sheet number in a formula

[ashish koul]

can u share excel file


On Sat, Oct 20, 2012 at 12:24 PM, Sundarvelan N  wrote:

> Hi Gurus,
>
> Please help me in this formula
>
> increase the sheet number in formula
>
> =IF(IF(ISNUMBER(can u share SEARCH(C$2,*Sheet1*
> !$B1)),"TRUE",0)="TRUE",TRIM(RIGHT(*Sheet1*!$B1,LEN(*Sheet1*
> !$B1)-FIND(":",SUBSTITUTE(*Sheet1*!$B1," ",":",LEN(*Sheet1*
> !$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1," ","")),0)
>
> I would like to increase the *Sheet1 to sheet2, sheet3 *down the rows.
>
>
> Thanks
> N.Sundarvelan
> 9600160150
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.