Maatangi,
your file has a link to a file called Database-formats11.xlsb that I don't
have, so I'm not sure if I can do much testing.
However, as far as the locked/protected cells go:Record a macro in which you
Protect the sheet (with a password) and making appropriate selections.then
unprotect i
On Mon, 3/6/17, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Monday, March 6, 2017, 11:2
On Mon, 3/6/17, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Monday, March 6, 2017, 10:2
On Mon, 3/6/17, Maatangi M. Karthik wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "MS EXCEL AND VBA MACROS"
Cc: schreiner_p...@att.net
Date: Monday, March 6,
On Fri, 3/3/17, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Friday, March 3, 2017, 3:4
On Fri, 3/3/17, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Friday, March 3, 2017, 1:5
First of all (last of all?):You can lock some cells and leave others available
for editing:- select all cells- right click on the selection - Select "Format
Cells"- select "Protection" tab- Make sure "Locked" is checked.- click "OK"
When the sheet is protected, all cells with this "locked" attrib
On Fri, 3/3/17, Maatangi M. Karthik wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "MS EXCEL AND VBA MACROS"
Cc: schreiner_p...@att.net
Date: Friday, March 3,
Hi there are a few more things I want from the excel.
1. There are some formulae in my excel sheet, I would like to convert them
to the backend so that the users cannot change them at any cost
2. There are some fields that affect these formulae in succession, that is,
two or three cell values t
Thanks a lot for your response, Paul.
However, my issue got resolved with the help of another forum and was
resolved with the help of Combination of "On error resume next " and
"Application.EnableEvents=False / true" statements.
On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul Schreiner wrote:
On Fri, 3/3/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Friday, March 3, 2017, 4:4
On Fri, 3/3/17, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Friday, March 3, 2017, 4:0
On Fri, 3/3/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Friday, March 3, 2017, 3:5
On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Date: Thursday, March 2, 2017, 1
On Thu, 3/2/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "excel-macros@googlegroups.com"
Date: Thursday, March 2, 2017, 9:32 PM
I dele
On Thu, 3/2/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "excel-macros@googlegroups.com"
Date: Thursday, March 2, 2017, 9:32 PM
I dele
I deleted a row and received the "Type Mismatch" error.If you select "Debug",
you'll see that the offending line of code is: If Target.Value =
"OrderStatus" ThenPutting a "watch" on the Target variable, you'll see that it
isn't a single cell, but an array of cells!
When you change multiple ce
I took a quick look myself.There doesn't seem to be a "standard" data type
called "Table".
Where you've used it before, do you have other macros (or class modules) that
define this data type?
In the other application (that works) try right-clicking on the word "Table"
in: Dim myTable As Table an
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
On Satu
Dear Paul Sir,
Good Morning.
Thank you so much for your code, for the effort and time dedicated.And your
explanation is too good but bcos of less understanding VBA coding I cant
get all information but any way i sort out my issue.Currently i Use Excel
2003 & future planning to work on excel 2007.
See answers below:
On Friday, November 4, 2016 2:00 AM, amar takale
wrote:
Dear Paul Sir,
This is fabulous work!
I think this must be flashing on the front page! :D. And I am Extremely sorry
for so late reply bcos of diwali vacation. I am VBA learner so only basic
knowledge of VBA
Dear Paul Sir,
This is fabulous work!
I think this must be flashing on the front page! :D. And I am Extremely
sorry for so late reply bcos of diwali vacation. I am VBA learner so only
basic knowledge of VBA coding.
I have some Question here:
1) Can I use this code in excel 2007 after giving ch
OK, here's something to look at.
I'm not sure if you'll need help implementing it, but here's how it works:
There are several "Named Ranges".For instance, your entire list is called
"Data" in order to manage the Filters.The cell for "place" is called
"SearchPlace" and the cell for strings is call
Dear Hilary sir pls look into this matter.
Also from Paul sir expect lot.
On Mon, Oct 24, 2016 at 5:42 PM, amar takale wrote:
> Dear Sir
>
> Thanks for reply.but my requirement not this way (And I am use excel
> 2003). I want to search any string from specific cell (D2) then data filter
> on th
Dear Sir
Thanks for reply.but my requirement not this way (And I am use excel 2003).
I want to search any string from specific cell (D2) then data filter on
that basis like wildcard criteria.
My search criteria like hotmail,gmail,water,emirates,net,.com,.ae ,wave etc
from D2 & then filter data
See attached, HTH. Cheers
On Mon, Oct 24, 2016 at 5:35 AM, amar takale wrote:
> Dear Friends
> any one help me on this issue
>
> On Fri, Oct 21, 2016 at 12:09 PM, amar takale
> wrote:
>
>>
>> --
>> 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)
Dear Friends
any one help me on this issue
On Fri, Oct 21, 2016 at 12:09 PM, amar takale wrote:
>
> --
> 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
Hey Bil,
You can do this thru formula only.
Enclosed without macro solution, let us know if you still required macro.
--
On Sun, Sep 18, 2016 at 8:42 AM, Bill Q wrote:
> Please see attached.
>
> Looking for a macro to automate a repetitive task.
>
> 1. It is to look for a specific text in Col
Thank you
On 13 September 2016 at 22:39, Learner Excel wrote:
> No,
> you can not add more thn 250 ppls
>
> --
>
> On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote:
>
>> is there any option in whatsup appln to add unlimited members(in single
>> group)
>> paid or free ?
>>
>> On 11 September 2016
No,
you can not add more thn 250 ppls
--
On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote:
> is there any option in whatsup appln to add unlimited members(in single
> group)
> paid or free ?
>
> On 11 September 2016 at 11:50, Learner Excel wrote:
>
>> Thanks Prabhu!..
>>
>> Happy to here from yo
is there any option in whatsup appln to add unlimited members(in single
group)
paid or free ?
On 11 September 2016 at 11:50, Learner Excel wrote:
> Thanks Prabhu!..
>
> Happy to here from you!>=.
>
> --
>
> On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky
> wrote:
>
>> Hi Friends,
>>
>> Since i h
Thanks Prabhu!..
Happy to here from you!>=.
--
On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky
wrote:
> Hi Friends,
>
> Since i have created Whatsapp group for VBA Macro learners/experts.
>
> And i have added many peoples in this group. Please Msg me to 9500087194
> in whatsapp to get added in
yes
On Wednesday, September 7, 2016 at 11:32:24 AM UTC-4, XLS S wrote:
>
> Do you need all values from brackets or some specif .
>
> --
>
> On Wed, Sep 7, 2016 at 8:41 PM, Pierre
> > wrote:
>
>> here it is
>>
>> On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote:
>>>
>>> sorry typo
Do you need all values from brackets or some specif .
--
On Wed, Sep 7, 2016 at 8:41 PM, Pierre wrote:
> here it is
>
> On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote:
>>
>> sorry typo error,
>>
>> Can you please upload some sample ASCII file if possible
>>
>> --
>>
>> On Wed
here it is
On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote:
>
> sorry typo error,
>
> Can you please upload some sample ASCII file if possible
>
> --
>
> On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel > wrote:
>
>> Can you please upload some same ASCII same file if possible
>>
sorry typo error,
Can you please upload some sample ASCII file if possible
--
On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote:
> Can you please upload some same ASCII same file if possible
>
> --
>
> On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
>
>> the data is an ASCII file that I need
the data is an ASCII file that I need to parse
On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote:
>
> Hi Pirerre,
>
> Please help me understand -
> 1. Is this in excel only?
> 2. There is any unique identifier if the blocks are more than one.
>
> Suggestions -
> 1. We can you us Te
Can you please upload some same ASCII same file if possible
--
On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
> the data is an ASCII file that I need to parse
>
> On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote:
>>
>> Hi Pirerre,
>>
>> Please help me understand -
>> 1. Is this
Hi Pirerre,
Please help me understand -
1. Is this in excel only?
2. There is any unique identifier if the blocks are more than one.
Suggestions -
1. We can you us Text to column than use some formulas to make table
2. You can extract value thru using LEFT,RIGHT formula
--
On Wed, Sep 7, 20
Upon investigation, the simplest solution seems to be to:-Make sure you have a
formula that recalculates when filters change. (I used =Count(A:A) in one of
the header cells) - Create a Worksheet_Calculate event macro.
In that macro, you can check to see if the worksheet is filtered: If
(Acti
Thank you very much.
I'm learning VBA
Thanks
N.Sundarvelan
9600160150
On 19 August 2016 at 22:34, mrExcel4u wrote:
> Hi,
> Please use the below mentioned code on Add command Button click
>
> Private Sub CommandButton1_Click()
>
> Dim Rcount As Integer
>
> Rcount = Sheet1.Cells(Rows.Count, 1).E
Hi,
Please use the below mentioned code on Add command Button click
Private Sub CommandButton1_Click()
Dim Rcount As Integer
Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
Rcount = Rcount + 1
Range("b" & Rcount).Value = Me.TextBox1.Value
ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value
Ra
To compare two dates, use the DateDiff() function.
Something like:Sub ChkSort()
Dim nRow
For nRow = 1 To 10
Select Case DateDiff("d", Cells(nRow, "A").Value, Cells(nRow + 1,
"A").Value)
Case Is > 0
MsgBox "Sort is Ascending"
Exit For
Sub export_as_pdf()
Dim WordDoc As New Word.Document
Dim WordApp As New Word.Application
Set WordApp = CreateObject("Word.Application")
WordApp.Visible = True
Set WordDoc = WordApp.Documents.Open(ThisWorkbook.Path & "\xyz.docx")
Hello everyone,
Sorry forgot to share the file .
Thanks and Regards,
Gargee Singh
From: garge...@hotmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA to save each page of a mail merge document
seperately
Date: Wed, 16 Mar 2016 18:50:06 +0530
hello Group,
Need help
yes
On Tue, Mar 15, 2016 at 3:53 PM, Pramod Singh wrote:
> Bro have u knowledge of Excel automation?
>
> Pramod
> On 15 Mar 2016 14:24, "Anil Gawli" wrote:
>
>>
>>
>> On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh
>> wrote:
>>
>>> This is notify to all guys who have good knowledge of VBA progra
Bro have u knowledge of Excel automation?
Pramod
On 15 Mar 2016 14:24, "Anil Gawli" wrote:
>
>
> On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh wrote:
>
>> This is notify to all guys who have good knowledge of VBA programming.
>> I have un Opning for the post of Vba developer.
>>
>> Please conta
On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh wrote:
> This is notify to all guys who have good knowledge of VBA programming.
> I have un Opning for the post of Vba developer.
>
> Please contact me on below mention details if any one interested.
>
> Profile Vba developer
> Location Gurgaon
> Cont
Dear Mr. Vikas,
If you look in the "FORUM RULES", you'll notice #3:
3) Don't post questions regarding breaking or bypassing any security measure.
Basically, programmers use passwords to protect their "Intellectual Property",
which is their livelihood.For myself and others, we would be unwilling to
Send me the file
On 5 March 2016 at 19:48, wrote:
> Hi all,
>
> I have an excel file which has multiple macros built. When I try to access
> the VBA, it gives a pop-up to enter the password. The macros have been
> written by predecessor and my boss wants me to decode this.
>
> Since i
dim ppApp As PowerPoint.Applicationdim ppReport As
PowerPoint.Presentationdim ppSlide As PowerPoint.Slidedim oPPTOLEObject_Text
as object
Set ppReport = ppApp.Presentations.Open("PPT Path")
ppApp.Visible = msoTrue 'Filling text boxes in ppt
Hi Mandeep,
I've changed my code to the following. In terms of the revision times, I
want to check whether it's following the format or not as well. Other than
that, I'm not sure how to put the date modified in it as well.
On Monday, 11 January 2016 17:50:35 UTC+8, Mandeep Baluja wrote:
>
>
Hey Kat,
I am sorry but i didn't get the logic of this code which is totally
different from your above query,Things which i understand its just checking
whether file_name following the criteria or not,
if 9th letter of the file name is equal to R then do something else show
error in all column
Hi Mandeep,
The revision time in my snapshot is the one I use writing. The real code
isn't showing. It's not showing the folder name and file name as well. In
terms of revision times, it's fine if the changes are done in certain
interval.
On Monday, 11 January 2016 15:34:15 UTC+8, Mandeep
Revision time ?? I have not heard about this while searching it on the
internet I found
this http://excel.tips.net/T002868_Using_Revision_Tracking.html which track
the changes done workbook shared on network. Is revision time being noted
anywhere in your workbook your snapshot is not showing wh
Hi Abhi,
Unfortunately, the code doesn't apply for my case.
On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote:
>
> Please see if this solves your purpose -
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=837
>
> On Mon, Jan 11, 2016 at 11:55 AM, Kat >
> wrote:
>
>> Hi Abhi,
>>
>
Please see if this solves your purpose -
http://www.vbaexpress.com/kb/getarticle.php?kb_id=837
On Mon, Jan 11, 2016 at 11:55 AM, Kat wrote:
> Hi Abhi,
>
> In terms of revision times, I want to show all the current revision times.
> Also, in the future, if there is any revision times being updat
Please elaborate what do you mean by "revision times". Do you want to show
the time when it was most recently updated or you want to show how many
times has it been updated?
On Mon, Jan 11, 2016 at 9:52 AM, Kat wrote:
> Hi all,
>
> I want to create a xlsm file which list out the folder name, f
I'm "slightly" confused by your example.
For your records:
| A | B | C |
| apr | C:\Users\pwloo\Desktop\break\goal\apr\2F6KB026 | 2F6KB026 |
Is the value in column "B" a folder? or a filename with path?Is the value in
column "C" a FILE that just happens to be the same name as the last folder nam
Run this code
Regards,
Mandeep baluja
Sub Parse()
>
> Dim hw As Long: hw = 2
> Dim k As Long: k = 2
> Dim j As Long: j = 2
> For i = 3 To 7
> Sheets(2).Cells(1, j).Value = "Col" & j - 1
> Sheets(2).Cells(k, 1).Resize(hw, 1).Value = Sheets(1).Cells(i, 1).Value
> Sheets("sheet1").Range(Cells(i,
Hi Paul,
Thanks for your replay,
my data having segment and 2 quarter values
i need below kind of report
Segment vlaues1 vlaues2
A (Q3) 1
A (Q4) 2
B (Q3) 1
B (Q4) 2
On Friday, 13 November 2015 02:01:19 UTC+5:30, Paul Schreiner wrote:
>
> Wha
What you've provided doesn't describe the logic.
Evidently, you want the Q3 figure and Q4 figure for each segment,but is the
column intended to shift for each subsequent segment?
Will the original data set be sorted by segment?
If so, it would be fairly easy to generate the code.
Paul
I'd use:Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim cell As Range
If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing Then
For Each cell In Target
If cell.Value <> "" Then
cell.Offset(0, 1).Value = Application.UserName
PFA...
On Mon, Oct 26, 2015 at 4:02 PM, Pravin Gunjal wrote:
> Dear Friends
>
> I have attached an excel file in which I have used macro to get "Created
> by" field automatically once the values are entered in column N (Qty).
> Likewise I want the last column (Entry Date) to be updated as curren
can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: mani bolla
To: excel-macros@googlegroups.com
Sent: Thursday, October 22, 2015 2:03 PM
Subject: Re: $$Excel-Macros
Hi paul,
i tried , but i am looking for a code, so i can customize , if i recorded
with macro i may get hard code values.
Request you to provide code.
Regards
Mani
On Thu, Oct 22, 2015 at 11:28 PM, Paul Schreiner
wrote:
> Have you tried recording a macro and then using "Remove Duplicates" fro
Have you tried recording a macro and then using "Remove Duplicates" from the
Data tab?
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long
Hi,
Please find the attached file.
If you have any concern let me know.
Regards,
Ganesh N
On Thu, Jun 18, 2015 at 8:41 PM, Naftali Herscovici <
tuli.herscov...@gmail.com> wrote:
> Hello,
>
> I need to evaluate an algebraic expression.
>
> Example - start
>
> dim a,b,c as string
> dim x as str
Hi Greg P
Thanks for sharing.
On Thu, May 21, 2015 at 10:46 PM, Greg P wrote:
> maybe someone will need
>
>
> http://training-course-material.com/training/Visual_Basic_for_Applications_(VBA)_in_Excel_-_Introduction_to_programming
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo
Practice can teach you excel, because nobody knows the end of Excel.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Thursday, May 21, 2015 at 8:21:02 AM UTC+5:30, rahulbhardwaj1986 wrote:
>
> Hi Al
Hi All,
Any one can suggest me good coaching institute for excel coaching in Delhi.
Regards
Rahul
On Thu, May 21, 2015 at 2:48 AM, mayur wrote:
> Hi Experts,
>
> I am looking for vba code for force selection of drop down value if
> specific column's cell value changes. Also, force user to ente
Hey vabz i tried and put the id in the tag here it is 3 its is working but
when i stopped the code and let the radio button to be visible first.
Let me clear it
on page there is one radio button when i click it open two radio button
when i select second one it opens many radio buttons with i
i copied 4 of your lines & created HTML file & its working correctly..
On Fri, Feb 13, 2015 at 5:11 PM, Mandeep Baluja
wrote:
> Tried this code earlier not working ,may be python will be used to achieve
> this.
>
>
> value="OC_GATI_CHENNAI_" type="radio" id="1">
>
>
>
>
> On Friday, February 13
Tried this code earlier not working ,may be python will be used to achieve
this.
On Friday, February 13, 2015 at 4:58:02 PM UTC+5:30, Vabz wrote:
>
> try this:
>
> Dim btn As Object
> Dim hEle As Object
> Set hEle = IE.document.getElementsByName("selectedCode")
> For Each btn In hEle
>
try this:
Dim btn As Object
Dim hEle As Object
Set hEle = IE.document.getElementsByName("selectedCode")
For Each btn In hEle
If btn.Value = "OC_GATI_CHENNAI_" Then
btn.Click
Exit For
End If
Next
Cheers!!
On Fri, Feb 13, 2015 at 2:45 PM, Mandeep Baluja
wrote:
> hey vab
hey vabz, as i clicked this radio button on webpage with vba
ieRadio.Item("ffModels")(0).Checked = True
it shows list of vendors with there tags on the same page like this below
syntax upto 1 to 10 and i want to press that particular radio button with
value for example ocgatichennai i want t
This works withe me..
IE.document.getElementsByName("selectedCode").Item(0).Checked = True
Cheers!!
On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Joshi wrote:
> can you share webpage url where you are performing this?
>
>
> On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja
> wrote:
>
>> > class="rad
can you share webpage url where you are performing this?
On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja
wrote:
> class="radio_type">
>
> Achieved code : - ieRadio.Item("radio_fulfillment")(0).Checked = True
>
> ieRadio.Item("ffModels")(0).Checked = True
>
> Achieved code id="radio_oneshipve
Great!!
ᐧ
On Tue, Jan 20, 2015 at 6:34 PM, sach so wrote:
> Dear Vabz,
>
> Thanks! It works as i required.
>
> Regards,
> Sachin
>
> On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:
>>
>> Sach,
>>
>> Amended code to suits your need..
>>
>> Cheers!!
>>
>> On Fri, Jan 16, 2015 at 5:
Hi Charlie,
Check this.
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
Double Cheers to you.
--
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 titles, like Please Help,
Cheers Buddy..
ᐧ
On Thu, Jan 22, 2015 at 1:08 PM, Ashish Kumar
wrote:
> Formula is working Well. Nice Solution Vaibhav bhai.
>
>
> 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
Formula is working Well. Nice Solution Vaibhav bhai.
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate threa
check this Attachment..
ᐧ
On Thu, Jan 22, 2015 at 12:58 PM, Vaibhav Joshi wrote:
> Hi
>
> Put your value in Cell A1 & put below formula in B1 & copy and paste it
> next columns
>
> =TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),(COLUMN(A$1)*99)-98,99))
>
> Cheers!!
> ᐧ
>
> On Thu, Jan 22, 2015
Nice solution Vaibhav Bhai.
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread tit
Hi
Put your value in Cell A1 & put below formula in B1 & copy and paste it
next columns
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),(COLUMN(A$1)*99)-98,99))
Cheers!!
ᐧ
On Thu, Jan 22, 2015 at 12:25 PM, Ashish Kumar
wrote:
>
>
> Elaborate more with Example
>
> On 22 January 2015 at 12:12, s
This code is not complete, do check & report..
ᐧ
On Thu, Jan 22, 2015 at 11:20 AM, sswcharlie wrote:
> Hi
>
> Excel2000
>
> On code below I get a 'syntax' error. On row- Intersect. Code
> off the net. Have tried some things but no luck. What have I missed ?
>
> Option Explicit
> Pri
Elaborate more with Example
On 22 January 2015 at 12:12, sswcharlie wrote:
> HI
>
> Have cells that have had serial numbers entered (up to 50 serial numbers)
> each separated by a comma.
> Is there a VBA argument that can take the cell and transfer each serial
> number to its own cell.
> Part of
Dear Vabz,
Thanks! It works as i required.
Regards,
Sachin
On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:
>
> Sach,
>
> Amended code to suits your need..
>
> Cheers!!
>
> On Fri, Jan 16, 2015 at 5:28 PM, sach so >
> wrote:
>
>> Dear Expert,
>>
>> I required some changes in VBA
Sach,
Amended code to suits your need..
Cheers!!
On Fri, Jan 16, 2015 at 5:28 PM, sach so wrote:
> Dear Expert,
>
> I required some changes in VBA, file attached here. I have data sheet,
> for Input i have input sheet & for output have output sheet. when I run
> macro i will get output.
>
> *
groups.com
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ VBA to Vlookup from other Source!
>
> hmn.writing macro is very easy, however as long as solution exist
> using available resources then same should be explored..
>
> +
> *I did not do
Reason behind is,
I am Working on a multiple manual task in one report, like already
enquired, pulling data from Text file, changing data formats, based on this
data pull information from other source, clean up templates. etc
regards,
saravanan R
On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja
cel-macros@googlegroups.com
Date: Tue, 30 Dec 2014 12:38:55
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA to Vlookup from other Source!
hmn.writing macro is very easy, however as long as solution exist using
available resources then same
hmn.writing macro is very easy, however as long as solution exist using
available resources then same should be explored..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja
wrote:
> Haha, Same question from my side to
>
> Haha, Same question from my side too Vabz but i was still trying to get
> it. Too much logical by calling it with udf because whenever you're writing
> a function the excel files during browsing cant be opened.
>
Trying this Macro to achieve the result.
Option Explicit
Public Sub Tes
why you need macro when you simply get it done using builtin excel dialogue
box..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 10:34 AM, saravanan R wrote:
> i am looking for VBA Macro for this , reference file to opened by browse
> option t
i am looking for VBA Macro for this , reference file to opened by browse
option then select the range.
thanks & regards,
Saravanan
On Mon, Dec 29, 2014 at 6:45 PM, saravanan R wrote:
> Hi Team,
>
> Please help me on Vlookup function where I will need to refer the file(by
> browsing the path) an
Hi
Yes you can do so..Keep both the file open & goto cell where yo need to
insert formula and start vlookup dialogue box by pressing Shift + F3 ..
When dialogue box appears select vlookup from Lookup & reference category
and press enter..now select look value from col A, press tab & you will be
i
You did not acknowledged response on last Query!!
Read rule # 4) Acknowledge the responses you receive, good or bad.
+
*I did not do this for you. God is here working through me for you.*
On Sun, Dec 21, 2014 at 2:22 PM, sanjai Kumar wrote:
> Dear All,
>
>
> PFA. there have two column we w
share an example sheet for better idea...
atleast 5 instances
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 2, 2014 at 4:41 PM, Mahesh Patil wrote:
> Hi Paul,
> Thans for reply.
> I am looking to create variable at runtime.
>
> Ex:
> Sub test()
> Dim X
1 - 100 of 595 matches
Mail list logo
