Hi Karan,
PFA...
Use this formula for unique extraction:
=IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),"")
And for counting unique numbers:
=SUM(1/COUNTIF(A1:A11,A1:A11))
Thanks & Regards,
*Deba Ranjan P*
On Sat, Jul 7, 2012 at 11:58 AM, Deba Ranjan wrote:
I am Zero in VBA Macros but attracted toward them just because i know excel
formulas has limitations.
I want to understand the code written by Noorain Bhai..,,
Secondly, the code by Don is perfect for me but there is a problem, i.e. It
add a row in the sheet , not in the table only.
So suppose
Wow,
Great,
Marvellous,
I gets excited when I see the beauty of Macros...
A combination of few words can do a lot for you.
Thanks to everyone, Ansari, Asa, Tag & the one whose macro i have applied
ie.. Don
Thanks
On Friday, July 6, 2012 7:06:37 PM UTC+5:30, Don Guillett wrote:
>
> You could
Hi,
One more contest coming in below mail for all excel users and champions ...
Please go through and win it
$300 will be awarded to the most smoothly operating, cleanly developer and
user friendly application.
$150 for 2nd place and $50 for third. Winners will also receive engraved
awards
--
Hi B Sharma,
One option not mentioned is to protect the sheet from VBA using the
UserInterfaceOnly option. With this option, your VBA code does not have to
unprotect the sheet - it has untethered access. The sheet will be protected
from direct interaction with the user only.
For that, you co
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html
http://msdn.microsoft.com/en-us/library/hh243933.aspx
http://support.microsoft.com/kb/146055
On Fri, Jul 6, 2012 at 11:03 PM, Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com> wrote:
> Hi Sir
>
> Thanks for introducing me the us
Hi Sir
Thanks for introducing me the use of dynamic range assignment.
thanks a lot for you help.
can there be VBA code as an alternative to using dynamic range for drawing
the chart? If yes, will you please introduce me to that as well?
*Sandeep Kumar Baranwal*
Credit Risk Methodology & Wholesal
Hi Sandeep ,
Is that what you wanted. ?
Actually I have used Dynamic Ranges in the charts . so no vba code needed to
update the chart at the time of adding data,
You can see the name ranges by pressing Ctrl+F3
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-mac
Dear Preston,
Please post your query.
On Fri, Jul 6, 2012 at 8:34 PM, Preston Moore wrote:
>
> http://www.dashing-dandy.com/wp-content/plugins/zmooresummm/ogpmgd.html?a=rpefjkjk
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thr
which chart you want to create can you share the chart.. so that we can
write the vba code for the same ..
Regards
Ashish
On Fri, Jul 6, 2012 at 10:21 PM, Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com> wrote:
> Respected Rajan Sir
>
> I am not able to locate the related VBA code in th
Respected Rajan Sir
I am not able to locate the related VBA code in the attached excel sheet.
Will you please provide the VBA code.
*Sandeep Kumar Baranwal*
Credit Risk Methodology & Wholesale Basel
Gurgaon
Mob:-08588802543
On Fri, Jul 6, 2012 at 9:02 PM, Rajan_Verma wrote:
> ** **
>
> ** **
hi don thanks for your help but i wanted to ask you is there a way to do
the same task without loop because it will go to all the sheets that are
mention in the table but for some reason i want to do the same task without
loop for that matter i want something like this
it should go to every sh
I am out of the office until 16/07/2012.
Any queries please contact x54455
Note: This is an automated response to your message "$$Excel-Macros$$
Digest for excel-macros@googlegroups.com - 25 Messages in 12 Topics" sent
on 6/7/2012 4:21:06 PM.
This is the only notification you will receive wh
B Sharma
Please see attached file ,I think is what you need
Chilexcel
2012/7/6 ChilExcel
> B Sharma
>
> Please see attached file ,I think is what you need
>
>
> Chilexcel
> 2012/7/6 B Sharma
>
>> Dear Friend Noorain,
>> Thanks for your quick reply...
>>
>> I tried this but failed, I was una
B Sharma
Please see attached file ,I think is what you need
Chilexcel
2012/7/6 B Sharma
> Dear Friend Noorain,
> Thanks for your quick reply...
>
> I tried this but failed, I was unable to insert rows in the table.
> I have attached a file for your reference too.
>
> Please see and help.
>
> B
thanks don but what if the sheets name are in M column and range names are
in N column???
Regards,
Avinash
On Friday, July 6, 2012 9:00:40 PM UTC+5:30, Don Guillett wrote:
>
> And, if as shown you want the cells populated with the name in col A,
> NO selections are necessary or desirable.
>
You could have looked in the vba help for cells
cells(1,1) is the same as cells(1,”a”)
cells(2,”M”)
cells(2,”N”)
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Avinash
Sent: Friday, July 06, 2012 10:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$E
Do you want this ?
See the attached sheet.. you can append table
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandeep Kumar Baranwal
Sent: 06 July 2012 8:51
To: excel-macros@googlegrou
hi don thanks for your help
and sorry for i was not able to explain my requirement but can u please
explain me how this code is working and what if the range table which is
mentioned in A and B column is in M and N column???
what will be the code???
Regards,
Avinash
On Friday, July 6, 2012 8
And, if as shown you want the cells populated with the name in col A, NO
selections are necessary or desirable.
Sub PopulateAllSAS()
With Sheets("settings")
dim I as long
For i = 2 To .Cells(Rows.Count, 1).End(xlUp).Row
Sheets(CStr(.Cells(i, 1))).Range(.Cells(i, 2)) = .Cells(i, 1)
Next i
End Wi
Respected Rajan Sir
thanks a lot for the quick response.
However, my requirement is to draw two graphs in one chart itself:
1) year (along x-axis) versus age (along y-axis (primary axis))) and
2) year (along x-axis) versus salary (along y-axis (secondary axis))
and the chart must incorporate ever
Hi All,
Waiting for your reply. Please do the needful.
Regards
Lokesh.M
On Thu, Jul 5, 2012 at 7:24 PM, Lokesh Loki wrote:
> Hi Rajan,
>
> 1. Just i want macro for working days instead of formula based on user
> id's.
> 2. All ready you have given me a formula for macro timings but the user
>
Had you explained that you want to select the appropriate range in ALL sheets I
would have offered.
Sub selectallSAS()
dim I as long
With Sheets("settings")
For i = 2 To .Cells(Rows.Count, 1).End(xlUp).Row
Application.Goto Sheets(CStr(.Cells(i, 1))).Range(.Cells(i, 2))
Next i
End With
End Sub
Do
If ? I understand your need try this
Sub insertrowsifSAS()
dim I as long
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
lr = Cells(Rows.Count, i).End(xlUp).Row
If lr > 1 Then Cells(lr, 1).Resize(Int(Cells(1, i)) + 1).EntireRow.Insert
Next i
End Sub
Don Guillett
Microsoft Excel Develo
use pkzip software with batch file
help pkzip/?
On Thu, Jul 5, 2012 at 7:46 PM, Venkat CV wrote:
> Dear All,
>
> I want to Compress all the files(.zip) to the specified folders with the
> password..Where i will have a passwords towards that file names..
>
> have attached sampl
If?? I understand what you want, right click sheet tab>view code>insert
this>double click on sheet name in column A
Private Sub Worksheet_BeforeDoubleClick (ByVal Target As Range, Cancel As
Boolean)
If Target.Column <> 1 Then Exit Sub
Application.Goto Sheets(CStr(Target)).Range(Target.Offset(, 1
Hi rajan it is not working i am getting this error "Subscript out of range"
Regards,
Avinash
On Friday, July 6, 2012 6:16:27 PM UTC+5:30, Rajan_Verma wrote:
>
> Use this:
>
>
>
> Sub SelectRange()
>
>
>
> Dim WksSheet As Range
>
> Dim rngRange As Range
>
> Dim rngCell As Range
You could just allow row insertion option before protecting or
ActiveSheet.Unprotect Password:="Don"
Rows(ActiveCell.Row).Insert
ActiveSheet.Protect Password:="Don"
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, July 06,
Dear Friend Noorain,
Thanks for your quick reply...
I tried this but failed, I was unable to insert rows in the table.
I have attached a file for your reference too.
Please see and help.
BS
On Friday, July 6, 2012 5:15:20 PM UTC+5:30, B Sharma wrote:
>
> Dear Excel Experts,
>
> I have a protec
Use this:
Sub MakeChart()
Dim wksSheet As Worksheet
Dim chtChart As Chart
Set wksSheet = Sheet1
Set chtChart = wksSheet.Shapes.AddChart(xlBar, 200, 200, 600, 200).Chart
chtChart.SetSourceData Range("A1").CurrentRegion
End Sub
Regards
Rajan ver
Use this:
Sub SelectRange()
Dim WksSheet As Range
Dim rngRange As Range
Dim rngCell As Range
Set rngRange = Sheet1.Range("A1").CurrentRegion
For Each rngCell In rngRange.Columns(1).Cells
ThisWorkbook.Worksheets(rngCell.Value).Activate
Dear BS,
Please try it, change some line as per your exact need.
Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox("Enter number of rows to insert", "Your Call")
If InsQuan <= 0 Then
MsgBox "Invalid number entered", vbCritical, "Stop!"
Exit Sub
End If
Applica
Dear Excel Experts,
I have a protected data sheet, where I want to insert row where the cursor
is selected.
I need a VBA code who will do the following:
1. Unprotect the sheet (with password)
2. Insert a row in the table where the cursor is pointed.
3. Protect the sheet (with password)
I need
Hi Asa,
Thank you very much for your help. This weekend I will analyze your
solution, many thanks in advance for your time and support, I expect to
give you feedback on this very soon :)
2012/7/4 Asa Rossoff
> Hi Jorge,
>
> OK, here you go!
>
> ** **
>
> I created a new flat table with
Thanks Noorain
this is the file, what i want.
On Fri, Jul 6, 2012 at 11:51 AM, Amresh Maurya wrote:
> Pls Follow Rule No 1
>
> 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
sorry don
i am busy in meeting last 2 days, not replyed for your mail.
On Wed, Jul 4, 2012 at 7:39 PM, dguillett1 wrote:
> I won’t speak for others but your plea for “urgency” makes me NOT
> respond as all requests are urgent and yours is no more urgent than others.
>
> Don Guillett
> Micro
Dear Amit
Please write a code in your workbook open event
on error resume next
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources,
Type:=xlExcelLinks
Dhartikumar Sahu
On Fri, Jul 6, 2012 at 2:21 PM, Amit Gandhi wrote:
> Hi Noorain
>
> I think you haven't understood what I want. You
Hi Noorain
I think you haven't understood what I want. You are giving me code to
UPDATE LINKS in other files. But I need something different. I am sitting
in File1 and I want code to update links of File1 itself.
1st Example -->
I have file named "File1", which have too many external links to dif
On Friday, 6 July 2012 12:29:14 UTC+5:30, vijay yadav wrote:
>
> Hi Experts,
>
> I need a macro which coluld do the following
>
> 1)top row contains integer 1 to 50 from B column to BZ column
>
> 2)other rows contain entries in column A
>
>
> 3)Also rows contains one entry beneath the
39 matches
Mail list logo
