Use this if you have data for this month only small and simple
=SUMPRODUCT(--((DAY($B$2:$B$15)=DAY(D2
Regards,
Mandeep baluja
On Friday, September 12, 2014 2:34:42 PM UTC+5:30, Chandru wrote:
>
> Hello,
>
> How to get unique values based on two conditions. Could you he
Who is Vabz and how much experience he' having ?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
i have a question that i have a list of entries with duplicates what i want
is how to get the distnict values(values which occur only one time) .
Please read my question carefully, I am not asking for removing duplicates
what I want is how to get the list of data which occured 1 time only in t
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1, Column B. If there is
a match, then copy/write the row of WS1 to WS 2. but in my code I am
retreiving the values through cells one by one I want *if cell matches
I have made this code for I have two worksheets that are in the same
workbook.
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
>
> I have made this code for I have two worksheets that are in the same
> workbook.
>
> I want to check the values of WS 2, C
Kindly find the file attached.
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
>
> I have made this code for I have two worksheets that are in the same
> workbook.
>
> I want to check the values of WS 2, Column B to WS 1, Column B. If there
> is
Awesome ashish
On Tuesday, November 11, 2014 1:11:31 PM UTC+5:30, Ashish Kumar wrote:
>
> Hi Saleem,
>
> PFA
>
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.face
Yes there is option in excel to split the data in seperate column as same
format of pdf .
On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote:
>
> Hello ,
>
> I need your help with regards to the attached macro file.
>
> I am trying to convert the pdf file to excel format but the
One thing I let you know that you're are truely awesome in excel and in
concepts the way you answering the questions of Excel VBA related. Wish you
good luck for you future.
On Monday, September 15, 2014 5:41:09 PM UTC+5:30, Mandeep Baluja wrote:
>
> Who is Vabz and how much ex
I got understand it today . thanks vab I can't expect this kind of
formula what a logical thinking .
On Saturday, August 16, 2014 8:02:59 PM UTC+5:30, Vabz wrote:
>
> Cheers !!
> On Aug 16, 2014 4:38 PM, "Rajan Verma" >
> wrote:
>
>> Wow
>>
>> On Monday, 11 August 2014 12:57:05 UTC-6, kapil
Hello kamal,
check dis out .
Private Sub CommandButton1_Click()
Dim brand As Long
Dim invoice As Long
Dim cell As Range
brand = TextBox1.Value
invoice = TextBox2.Value
temp = brand & invoice
Set ws1 = ActiveWorkbook.Sheets(1)
For Each cell In ws1.Range("a1", [a65535].End(xlUp))
If cell.Va
Use this
formula
=IF(COUNTIF($A$2:$A$64,VLOOKUP(A2,$A$2:$A$64,1,0))>1,"Duplicate","unique")
if you want to be specific for only using vlookup function in this you can
use =VLOOKUP(VLOOKUP(A2,$A$2:$A$64,1,0),A3:A64,1,0) if na received then
value is unique if value retreived value is duplicate.
Thanks Vaibhav I got to know that I have not entirerow while pasting the
data to sheet2 . thanks :)
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
>
> I have made this code for I have two worksheets that are in the same
> workbook.
>
> I want to chec
Hey Amit,
kindly find the attachment of data .
Thanks
*Mandeep Baluja *
On Tuesday, November 11, 2014 10:37:18 PM UTC+5:30, Anil Kumar wrote:
>
> how to use function show all location by country name
>
> pfa
>
>
> Regards,
>
> Anil Kumar Maurya
>
>
>
--
Hey Pol check this sheet and confirm you want this kind of filters or not .
*Thanks *
*mandeep Baluja*
On Wednesday, November 12, 2014 5:29:41 PM UTC+5:30, Pol Ktk wrote:
>
> Sir,
> in attached there are 2 sheet
> 1 sheet contain data in 2nd sheet need filter data
>
>
>
Hello All,
My name is Mandeep , I have been working as a MIS Executive since 1 year. I
have keen interest in excel and love the power of VBA. Hope I will help you
in some of your issues.
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Please explain the last line !! What's going on in that line what is \b ??
etc etc
Set re = CreateObject("vbscript.regexp")
re.IgnoreCase = True
re.Global = True
re.Pattern = "\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,6}\b"
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An
Thanks Broo. Have you got your MVP award :)
On Thursday, November 13, 2014 2:47:19 PM UTC+5:30, Mandeep Baluja wrote:
>
> Please explain the last line !! What's going on in that line what is \b
> ?? etc etc
>
> Set re = CreateObject("vbscript.regexp")
> re.Ign
Hey Kalyan,
check this formula and the sheet
. =COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0))
Ctrl+shift+Enter
Regards
Mandeep Baluja
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
>
> Dear Experts,
>
&g
Hey Kalyan,
check this array formula and the
sheet.
=COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0))
Regards,
Mandeep Baluja
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
>
> Dear Experts,
>
> Please help
Try Freeze panes
On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard wrote:
>
> Hi all,
>
> FInd attached an excel sheet, where in i pasted a circular shape in that
> sheet.
>
> Whenever i scroll down the row, or move accross the column, I want keep the
>
> circle on the same posi
Mr. Rafeeq Let me tell I have faced the same problem while preparing the
invoice for various vendors. I can only provide you the way to create each
and every sheet in separate pdf. if you want. But still question is I dont'
understand dt his amount will be calculated from Source Data!Sheet (G4)
May I know how duplicates are removing ?? as you have not wrote any command
but still duplicates removed in this code. Vabz.. How ?
Thanks in advance
Mandeep
Sub GetUniques()
Dim d As Object, c As Variant, i As Long, lr As Long
Set d = CreateObject("Scripting.Dictionary")
lr = Cells(Rows.Coun
you can set your default path by copying it in code there is no need to
change it again and again.
add these lines of code in bottom
Workbooks(file1 & ".xlsx").Close savechanges:=False
Workbooks(file2 & ".xlsx").Close savechanges:=False
Thanks
*Mandeep Baluja*
On
Use this code to apply filter do the changes as per your data.
Sub Filter()
Dim lastrow
Range("m2:q65536").Select
Selection.Clear
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range("A1:e" & lastrow).Select
Sheets("Mainsheet").Range("A1:e" & lastrow).AdvancedFilter
Action:=xlFilt
Dear Rupesh,
Please find the attachment .
Regards,
*Mandeep Baluja *
On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote:
>
> Hello experts,
>
> I need your help,I have one userform which attached with mail for your
> reference, what I need is add text bo
used name range to achieve the same :) it will not get shifted when you
named that cell and apply link on that.
Thanks
*Mandeep Baluja *
On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote:
>
> Dear All friends
>
> Pls solve my hyperlink issue.
>
> I
zeros and non-zeros in Column A and would like
to see the maximum number flanked by zeros in Column A's non-zero range in
Column B.
What formula should be written in cells in Column B?
A B
0 0
0 0
3 7
2 7
6 7
7 7
0 0
0 0
0 0
8 8
2 8
3 8
0 0
Regards
*Ma
=IF(D3="N/A",INDEX($D$1:$D$13,LARGE(IF($D$1:D3<>"N/A",ROW($D$1:D3)),ROW(D3:D3)-ROW(D2:D2)),1),D3)
Ctrl + shift + enter
Mandeep Baluja
Excel Specialist.
On Thursday, November 20, 2014 10:55:44 AM UTC+5:30, Rohan Young wrote:
>
> Dear Group,
>
> Please
Try dis kind of formulas. Don't delete the hide rows reference you can
shift it. I will provide you a solution soon for % column too.
Regards,
Mandeep Baluja
*Excel Specialist. *
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur wrote:
>
> Dear all, I need to extract
through the
sheet.Looking for a Macro which can correct the format of time
automatically.
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Dear Nur,
Thanks to appreciate.
Actually I was doing my office work yes it is possible to reference text
inside the formula.But I need time because I have to do my ofc work too :),
Soon I will submit it your percentage formula too.
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur wro
Hey Nur,
Kindly find the attached UDF just type the formula in sheet First
percentage/Second percentage it will give to appropriate result. if text
does not contain second percentage value it will give wrong result.
Function Firstpercentage(txt) As String
Dim k() As String
Dim x As Variant
Worked like a charm :)
Thanks a lot .
On Thursday, November 20, 2014 4:59:00 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I need to work on Data sheet which contains all the cells in text format.
> basically its a timing sheet. I want to change the format of all the
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
On Thursday, November 20, 2014 7:01:02 PM UTC+5:30, Mandeep Baluja wrote:
>
> Worked like a charm :)
>
> Thanks a lot .
>
&g
. If you have any idea to achieve this it
would be great help.
On Thursday, November 20, 2014 4:59:00 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I need to work on Data sheet which contains all the cells in text format.
> basically its a timing sheet. I want to change th
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month* *End Month* *FY 15-16* *FY 16-17* *FY 17-18* *FY 18-19* *FY
19-20* *FY 20-21*
*1-Apr-15* *30-Jun-19* *12* *12* *12* *12* *3* *0*
On Friday
Your're most Welcome.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote:
>
> Dear All friends
>
> Pls solve m
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY
20-21*
*1-Apr-15**30-Jun-19**12**12**12**12**3**0*
On Friday, November 21, 2014 3:27:20 PM
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
Next
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote:
>
&g
line of your code
except this , Debug.assert = True , If ((ActiveSheet.Range("A1").Value &
"X" = "X") _
And (ActiveSheet.Range("B1").Value & "X" <> "X")).
if(Query = True, " Paul will handle it,"" Paul wil
Hey Nur,
Kindly find the attachment. frankly speaking this is first time i made this
code without any help from blogs. :)
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Sunday, November 23, 2014 9:03
Set the columns for emails. it will take email one by one and send the mail
from outlook automatically without showing any notification you can also
use msgbox function to check the list of of users one by one. here the
email column is For Each cell In Range("AJ2:AJ300")
Regards,
Mand
Dear All,
I hope you have a correct idea for my question I am asking to select rows
in data with the help of loop. Please note that what i want is to run a
loop select a row move next and *keep the previous row selected too*. I
need a efficient code for this.
Regards,
Mandeep Baluja
Dear Chandru,
Kindly find the attached file.
Regards,
Mandeep Baluja
On Monday, November 24, 2014 5:41:42 PM UTC+5:30, Chandru wrote:
>
> Hello ,
>
> I need to display value as percentage could you please help me on attached
> file.
>
> Thank you,
>
> Chand
Hey Ashish, Dont you think it will be converted to text if you use that
formula.
On Monday, November 24, 2014 5:50:29 PM UTC+5:30, Ashish Kumar wrote:
>
> Hi Chandra Shekar,
>
> Use this formula :
>
> =A1& "%"
>
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Nopz but I just want to learn new things if it works bro.
On Monday, November 24, 2014 6:06:55 PM UTC+5:30, Ashish Kumar wrote:
>
> Dear Mandeep,
>
> Are you trying this formula.
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Chandru find the attachemnt ihad get given above it will take the format as
value. Ashish i know that its a concatenate function but as you are not aware
about the fact whenever a concatenate function is used with text that value
turned into a text .
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I hope you have a correct idea for my question I am asking to select rows
> in data with the help of loop. Please note that what i want is to run a
> loop select a row move next and *keep the previous row selecte
Sorry not working try this this also selecting the whole range.
On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I hope you have a correct idea for my question I am asking to select rows
> in data with the help of loop. Please note that
Sub Exercise()
Range("1:1,3:3, 5:5, 7:7").Select
End Sub
See this how this rows are selected I want automation for this with the
help of loop .
On Tuesday, November 25, 2014 11:21:46 AM UTC+5:30, Mandeep Baluja wrote:
>
> Sorry not working try this this al
p. what my query is for
alternate rows.
On Tuesday, November 25, 2014 11:30:40 AM UTC+5:30, Mandeep Baluja wrote:
>
>
> Sub Exercise()
>
> Range("1:1,3:3, 5:5, 7:7").Select
>
> End Sub
>
> See this how this rows are selected I wa
I just want to know whether it's is possible with the help of code or not.
I can achieve the same with the help of helper column using a mod function.
On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I hope you have a correct idea for
Haha and the *master (vabz) *comes and the query resolved. I was looking
for this code. I have seen this code somewhere but it was slipped out of my
mind.
Gud one bro.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com
ou. God is here working through me for you.*
>
> On Tue, Nov 25, 2014 at 12:51 PM, Mandeep Baluja > wrote:
>
>> I just want to know whether it's is possible with the help of code or
>> not. I can achieve the same with the help of helper column using a mod
>> function.
Does anyone has another code except this to loop files in folder and
perform operation on that file. ?? this code is correct but i want
different one.
Sub ListFiles()
Dim bookList As Workbook
Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As
Object
Application.ScreenUp
Filename)
Filename = Dir()
Loop
End Sub
the above code is not opening all the files. why ???
On Tuesday, November 25, 2014 3:41:16 PM UTC+5:30, Mandeep Baluja wrote:
>
> Does anyone has another code except this to loop files in folder and
> perform operation on that file
Don't worry I am not imposing this code on you to handle. I just want an
idea for doing this. This is about to highlight some rows data with the
help of conditional formatting. numerous of files reside in directory. I
want to iterate each file with the help of code which is working correctly.
Dear Sriram,
find the attached file.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, November 25, 2014 4:52:28 PM UTC+5:30, sriram ji wrote:
>
> Dear Guru's
>
> If F
> ""
Workbooks.Open (Pathname & Filename)
Filename = Dir()
Loop
End Sub
On Tuesday, November 25, 2014 3:41:16 PM UTC+5:30, Mandeep Baluja wrote:
>
> Does anyone has another code except this to loop files in folder and
> perform operation on that file
Sheet required !!
On Tuesday, November 25, 2014 5:49:28 PM UTC+5:30, Maria Carmel wrote:
>
> Hello,
> i need help with creating a "name and b-day" list that accumulates data ()
> from different worksheets of one excel file.
> new worksheets added constantly with the same columns (among them name
[h]:mm:ss
What is the keyboard shortcut to set the time in this format.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate t
build this hope this help someone else.
Sub Format_to_time()
Selection.NumberFormat = "[h]:mm:ss"
Selection.Font.Bold = True
End Sub
On Wednesday, November 26, 2014 3:29:40 PM UTC+5:30, Mandeep Baluja wrote:
>
> [h]:mm:ss
>
> What is the keyboard shortcut to set t
r knowledge?
>
> .
>
> Enjoy
> Team XLS
>
>
> On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja > wrote:
>
>> build this hope this help someone else.
>>
>> Sub Format_to_time()
>>
>> Selection.NumberFormat = "[h]:mm:ss&
ath and new path according to your convenience it will convert
xlsx files to csv in new path folder.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, November 26, 2014 4:40:03 PM UTC+5:30,
ile, Local:=True)
newpath = "C:\Users\pc\Desktop\a\"
k = Replace(wb.FullName, ".xlsx", ".csv")
q = Replace(k, SourcePath, newpath)
wb.SaveAs q
wb.Close True
Set wb = Nothing
strFile = Dir
Loop
End Sub
Regards,
Where can I find a list of all methods and functions for VBA in Excel. I
want it in readable format not while searching with the object explorer.
various website is showing but not a complete information in single link.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com
why dont you hide buttons on click and unhide on another
On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote:
>
> Hello experts,
>
> I need your help,I have one userform which attached with mail for your
> reference, what I need is add text boxes vertical on button every time
Replace source line with this
Set j = Application.FileDialog(msoFileDialogFolderPicker)
j.Show
SourcePath = j.SelectedItems(1)
On Wednesday, November 26, 2014 4:40:03 PM UTC+5:30, Muneera Shabana wrote:
>
> Good Morning,
>
> Hope you are having a great day!
>
> *Objecti
= Replace(k, SourcePath, newpath)
wb.SaveAs q
wb.Close True
Set wb = Nothing
strFile = Dir
Loop
MsgBox "The files are successfully converted into .csv format & placed in
target folder"
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://w
Sub test()
Dim sh As Worksheet
Dim sh1 As Worksheet
Dim sh2 As Worksheet
Set sh1 = ActiveWorkbook.Sheets("fullData")
Set sh2 = ActiveWorkbook.Sheets("sheet2")
sh1.Select
Range("2:2,4:4,5:5,10:10,11:11,15:15,16:16,17:17,22:22,26:26").Copy
sh2.Range("A2").PasteSpecial
End Sub
for time query ki
Hello daya,
there is no pattern to select rows in your Data. Define the pattern first.
On Friday, November 28, 2014 10:53:00 AM UTC+5:30, daya p wrote:
>
> sir,
> there is a huge data in my file
>
> On 28 November 2014 at 10:07, Mandeep Baluja > wrote:
>
>>
Do you want to get data in next sheet on Day wise criteria or time wise
criteria. row you have highlighted was for 8th nov and 9 th nov .
On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote:
>
> Sir,
> good evening to all
> i need help on attached sheet
> its a machine data of finan
Kindly find the solution i have used two helper column and a macro.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote:
>
> Sir,
Sub copysheet2()
ActiveSheet.Range(Range_name).Copy
Sheets(NewsheetName).Range("A1").PasteSpecial
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 2, 2014 1:01:46 P
Hello,
I need your help to acheive something with the help of regular expression
or by any way in vba. what i want is to concateneate a range of cells if
its cell is having duplicates then it should be concatenate only one time.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Thanks Vabz
On Tuesday, December 2, 2014 3:02:29 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hello,
>
> I need your help to acheive something with the help of regular expression
> or by any way in vba. what i want is to concateneate a range of cells if
> its cell is having duplica
dingly
For Each NM In WKB1.Names
WKB2.Names.Add NM.Name, NM.RefersTo
Next NM
MsgBox "Completed...", vbInformation
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQ
This question is for vabz, Mostly the queries answered by vaibhav
Are you working with a team or you are answering the queries by yourself
only ??? without getting help of someone,
because you're the only efficient programmer in vba here.And I am new in
this field.Can you recommend the best book
Hard work & Experience Pays off Way to gooo
On Wednesday, December 3, 2014 12:42:13 PM UTC+5:30, Mandeep Baluja wrote:
>
> This question is for vabz, Mostly the queries answered by vaibhav
> Are you working with a team or you are answering the queries by yourself
> only ???
Hey,
I am working on this code if i will not use statement *filename = Dir()*
then it goes into a infinite stage. May I know the reason why and why it's
stopped when i apply this line.
as Per the meaning of this line it will check all the rest of files.
Sub Select_Folder_and_copy_files_into_c
Try this resolve this query.
Trying to automate this any help will be appreciated.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RU
Good one bro/Sir( hmmm age? ) Awesome use of EO month and Day function.
On Wednesday, December 3, 2014 4:54:19 PM UTC+5:30, Mandeep Baluja wrote:
>
> Try this resolve this query.
>
> Trying to automate this any help will be appreciated.
>
> Regards,
> Mandeep
>
--
Ar
pty directory hence loop is continuing to infinite...
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, Dec 3, 2014 at 4:18 PM, Mandeep Baluja > wrote:
>
>> Hey,
>>
>> I am working on this code if i w
Thanks bro, Is this your link??
http://www.thinkvidya.com/mumbai/vaibhav-joshi/2391199
On Wednesday, December 3, 2014 4:54:19 PM UTC+5:30, Mandeep Baluja wrote:
>
> Try this resolve this query.
>
> Trying to automate this any help will be appreciated.
>
> Regards,
> Mandeep
While studying I got to know that Collection is the object that can take
only unique values with the key identifier and i am taking this advantage
of this. Another one which is having this special property is
Scripting.dictionary object. Can someone incorporate the usage of
scripting.dictionar
duplicates then only
Msgbox 1,2,3,6,7,8,9,10 will be retrieved in msgbox except 4 and 8 which is
duplicate.
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
>
> While studying I got to know that Collection is the object that can take
> only unique values wit
bj.Add cell.Value, k & cell.Value
Next
For i = 1 To dicobj.Count
MsgBox dicobj.Item(i)
Next
End Sub
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
>
> While studying I got to know that Collection is the object that can take
> only unique values
Thanks Paul for your code. Now I got your point. Vabz this is the best link
I have ever seen for VBA.
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
>
> While studying I got to know that Collection is the object that can take
> only unique values wit
Function F_concatenaterow_snb(c01)
F_concatenaterow_snb = Join(Application.Index(c01.Value,1,0), "|")
End Function
Is this Index function or other thing. How is it working.???
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
http://www.excel-formulas.com/sample-question/Password-Protect-Particular-Column-or-Row-in-Excel
On Friday, December 5, 2014 12:08:06 PM UTC+5:30, Putta Madaiah wrote:
>
> Hi Friends,
>
> How to protect only few cells with a password where users should not be
> able to update anything in a shared
an combine the array values with a delimiter. here the point is how
the increment is going on.
*MsgBox Join(arrColor, "&") *
On Friday, December 5, 2014 11:44:59 AM UTC+5:30, Mandeep Baluja wrote:
>
> Function F_concatenaterow_snb(c01)
>
> F_concatenaterow_snb = Join(
Can I get that file with the result
On Saturday, December 6, 2014 12:06:42 AM UTC+5:30, Paul Schreiner wrote:
>
> I have a worksheet template in which I display a 3-digit Product Code.
> I have a hidden worksheet that has a list of Product Codes and
> corresponding product names like:
> Code Prod
Kindly find the solution
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Saturday, December 6, 2014 9:14:25 AM UTC+5:30, Ashish_Bhalara wrote:
>
> Dear experts,
>
> I need function to
I have a question check this sheet. first shape is copied from some file
and other one is created by me. I want to know that while selecting first
one cursor is showing inside the shape and not on the second one while
selecting. basically I can't create that kind of shape which can take text
an
I want a Udf or macro to concatenate a range with two special criteria.
First:- in Range it select only visible cells
Second :- remove duplicates.
Kindly don't provide me any website as I have checked numerous of codes but
no code is achieving this combined result.
Regards,
Mandeep B
MADE FOR MYSELF, NO NEED TO REPLY
:)
On Wednesday, December 10, 2014 10:53:31 AM UTC+5:30, Mandeep Baluja wrote:
>
> I want a Udf or macro to concatenate a range with two special criteria.
> First:- in Range it select only visible cells
> Second :- remove duplicates.
> Kindly d
End Sub
Vabz check this out hope you will convert this in udf .
On Wednesday, December 10, 2014 10:53:31 AM UTC+5:30, Mandeep Baluja wrote:
>
> I want a Udf or macro to concatenate a range with two special criteria.
> First:- in Range it select only visible cells
> Second :
StrComp function through which assembly or references I can use this
function in vba.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
'Most of the people have asked this simple question that what is the
difference between activate and select method.
'Lets Start describing this
'Try this
'Range("A1:A10").Select
'Range("a3").Activate
'Your range will selected but the activecell is "A3"
'Activates a single cell, which must be ins
1 - 100 of 467 matches
Mail list logo
