Kindly help on the said issue.
Thanks!
On Mon, Sep 24, 2018 at 5:31 PM vikas khen wrote:
> Hi All,
>
>
>
> Kindly find the attached two sheets, based on the same I need Conditional
> formatting formula to highlight the cell value in color it the given
> criteria matches. I have mentioned the
*Regards,*
*For quick responds click here for Message *
On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta
wrote:
> I have a table where data changes continously (stock market data). I want
> to apply IF formula. please understand with given
On Tue, 6/20/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Tuesday, J
On Tue, 6/20/17, Mustapha LMIDMANI <lmidmani.musta...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: "excel-macros" <excel-macros@googlegroups.com>
Date: Tuesday,
I have fixed N° of product and fixed N° of customers.
It would be great if I can modify customer and product list in separated
sheet if I want to add or remove something :)
Many thanks Paul
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on
If you can give me a larger sample of data, I can try to work on
something.Since it sounds like you have no background with VBA programming,
I'll try to develop an Excel-Function solution.
Paul-
“Do all the good you can,
By all the means you can,
In all
adjective: dynamic1. (of a process or system) characterized by constant change,
activity, or progress.
That's why I defined the meaning in my question:
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Meaning, does the number
Sorry Paul, I didn't get what you mean by "dynamic".
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on the screen
*NOTICE:* This privileged and confidential email is intended only for the
individual or entity to whom it is addressed. With
That didn't answer my questions. 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
Hi dears,
Thanks for your feedback guys.
Paul: sheets are filled weekly (manually). and the dashboard have to
reflect data on sheets by selecting Customer and month
thanks in advance
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on the
There's not enough information for me to guess how you want the summary
populated.
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Paul-
“Do all the good you can,
By all the means you
On Sun, 6/18/17, Rajan Verma <rajanverma1...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Sunday, June 18, 2017, 7:09 PM
countif,
countif, sumif, sumproduct can do this
On Sun, 18 Jun 2017 at 9:23 PM, Mustapha LMIDMANI <
lmidmani.musta...@gmail.com> wrote:
>
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
>
On Thu, 6/8/17, Mustapha LMIDMANI <lmidmani.musta...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: "excel-macros" <excel-macros@googlegroups.com>
Date: Thursday,
Hi,
Can somone help on my issue please .
On 6 June 2017 at 10:50, Mustapha LMIDMANI
wrote:
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
> create
Thank you Paul, I've got a huge mental block on this type of expression. I
appreciate the help!
On Friday, June 2, 2017 at 11:56:24 AM UTC-4, Paul Schreiner wrote:
>
> Let's say that you have 100 rows of data.
>
> "bottom" ends up being 100.
> so your Rows statement results in:
>
Let's say that you have 100 rows of data. "bottom" ends up being 100.so your
Rows statement results in:Rows(R:100).insert shift:=xldown
I think it needs to beRows(100:100).insert shift:=xldown
so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown
Paul-
“Do
PFA Solved question..
On Thu, Jun 1, 2017 at 7:50 PM, Secret Shot wrote:
> Dear Team,
>
> I have one very large excel table which i made from Raw data, accidentally
> raw data has been deleted and the only option i have is that table to
> convert back in raw data.
>
> Its
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Friday, June 2, 2017, 4
On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Thursday, June 1, 2017, 6
Thanks Paul, This is exactly what i was needed. you are a life saviour
On Thu, Jun 1, 2017 at 11:34 PM, Paul Schreiner
wrote:
> In THAT case:
>
> If you name a range "Result" and have it include the "summary" table
> without the column headings or phone numbers
> B4:G9
In THAT case:
If you name a range "Result" and have it include the "summary" table without
the column headings or phone numbersB4:G9 in your sample
Then, name a range called "Data" that includes the original "Data" without the
column headingsL4:M1000 in your example.
Then you can use a macro
Dear Paul,
I appreciate your quick response, However when i say raw data it means just
simple table in Excel which i have shown in attached excel sheet only in
column L and M.
So you can consider it as requirement or data rearrangement from table 1
(Column A to G) to table 2 (Column L to M).
I
On Thu, 6/1/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Date: Thursday,
There is no standard format for "Raw Data".It depends on the original
Application used to CREATE the source of data.Some systems output ASCII (text)
files Some are tab delimited.Others are comma delimited (csv).
The mechanism you used to read in the "raw data" used known characteristics of
the
Hi Paul,
The macro for this one is not working.
Can you please share your file with macro. So i can compare with my file.
I am getting error message the data cannot be pasted as shape and size are
not same.
Regards,
Kaushik
On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner
What isn't working?What does your code look like?
I put random numbers in 100,000 cells in Book1.xlsbThen, in Book2, I put
100,000 cells with links to the corresponding cell in Book1.
I then created a macro module with:Option ExplicitSub RemoveLinks()
Dim aLinks, inx
aLinks =
Hi Paul,
The code is not working.
Can you please provide full code starting with Sub...till End sub
Regards,
kaushik Savla
On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner
wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of
On Tue, 5/23/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ Need help in Vba Macro
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Date: Tuesday, May 23, 2017, 9:53
Wow. This is what actually I require.
I will test in my file.
Thanks a lot.
On May 24, 2017 00:43, "Paul Schreiner" wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a given cell, the VALUE of the cell
If you also want to get rid of the "internal" links and formulas, you can make
use of the fact that, for a given cell, the VALUE of the cell is what is
displayed, while the FORMULA of the cell is just that, the formula.
For cells with a simple value, like "3", then the formula and value are
This is think will definitely help.
Thanks.
On May 24, 2017 00:23, "Paul Schreiner" wrote:
> That's very CPU intensive because it copies all cells to the clipboard
> and pastes them from clipboard.
> which can be a HUGE number of cells for each sheet.
>
> If you simply
That's very CPU intensive because it copies all cells to the clipboardand
pastes them from clipboard.which can be a HUGE number of cells for each sheet.
If you simply want to break the external links, you can use something like:
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not
Any hope on this _
Regards,
Vikken
On Wed, Mar 29, 2017 at 3:18 PM, vikas khen wrote:
> Hi Team,
>
> Kindly find the attached sheet. In this sheet in need actual value in stud
> of 1. hence kindly assist me on this.
>
> Regards,
> VikKhen
>
> --
> Are you =EXP(E:RT) or
You can create a Worksheet_Change event.check to see if the cell changed
(Target) is the cell with your pull-down selection, then process accordingly:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = "$A$4") Then
Debug.Assert False
End If
End Sub
Hi Team Any update regarding on the same??
Regards,
On Mon, Dec 19, 2016 at 9:51 AM, vikas khen wrote:
> Hi all,
>
> Good Morning!!!
>
> Team, need help for pooling data from Outlook2016 mails (Which is I kept
> in the one folder) to Excel Sheet in Desired format.
>
> my
Want to excel formula on this
Regards,
Mohd Sadiq
On Nov 21, 2016 6:54 PM, "Paul Schreiner" wrote:
> OK, I'd need a bit more information.
> I can make LOTS of assumptions, but I'd rather not do this multiple times.
>
> So, for each row of data, you want to determine
OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd
rather not do this multiple times.
So, for each row of data, you want to determine the FIRST column containing WO
and the LAST column containing WO.
Are you wanting to use VBA or Excel functions?
A simple function would
Team ,
Pls update on this
On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq wrote:
> Team , I have data where I want to first date of "WO" and last date of
> Week off in a week.
>
> attached is the excel sheet for your reference.
>
> Pls treat it on priority
>
>
>
> Regards
>
Thanks for Help
On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote:
>
> Try this one !
>
> [dp]
>
> On 10/10/2016 19:46, sonur...@gmail.com wrote:
>
> Hi
>
> I need help for separate data through VBA.
>
> My Data is below type..
> sku Size
> 10307963 XS,S,M,L
>
Use this Man
Sub SplitTest()
Dim VarArrayAs Variant
Dim LngRAs Long
Dim LngCAs Long
Dim LngIndexAs Long
Dim VaresultAs Variant
LngIndex = 1
VarArray = Intersect(Sheet2.Range("A1").CurrentRegion,
Sheet2.Range("A1").CurrentRegion.Offset(1))
Hi Try below VBA code
Option Base 1
Sub rr()
For Each r In Range("b2:b" & Range("b9").End(xlUp).Row)
x = Split(r, ",")
For t = LBound(x) To UBound(x)
Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1)
Range("i9").End(xlUp).Offset(1).Value = x(t)
Next
Next
End
HI Manju,
See this help you
--
On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote:
> Hi
>
>
>
> I need your help to create a macro for the below mentioned scenario.
>
>
>
> *Scenario*
>
>
>
> We need two columns namely User, drop down
>
>
>
> *“IF user enter data in
HI ,
not sure but have you tried using the value "true" in vlookup, might as
well work out for you. sorry in advance i am not a pro at it just amateur.
thanks & regars
On Mon, Jun 20, 2016 at 4:59 PM, Paul Schreiner
wrote:
> It works fine on my file.
> However, I
It works fine on my file.However, I noticed in YOUR file, the Calculation
option is set to "manual".
(A "Calculate" reminder appears in the Status Bar.You have to hit an F9 to
calculate.
which means, when you copy the formula down the column, it retains the original
value until you recalculate.
Hi Paul,
Thanks for your quick reply, However your suggested formula is not working
correctly it shows "No Record Found" for all the records. Hence request you
to kindly help me on this.
Regards,
On Sat, Jun 18, 2016 at 12:50 AM, Paul Schreiner
wrote:
> You're looking
You're looking for a function like:=IFERROR(VLOOKUP(F2,D:D,1,FALSE),"No Record
Found") 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 Paul,
Please find the details in the attached sheet.
Regards,
Vik
On Fri, Jun 17, 2016 at 5:53 PM, Paul Schreiner
wrote:
> What array are you talking about?
> Your file says:
> "If E2 value is in Array then it should reflect in F
> otherwise count as a not found"
>
What array are you talking about?Your file says:"If E2 value is in Array then
it should reflect in F otherwise count as a not found"
So, since column E is labeled as "id", then I suspect you want to look in an
array of ID's.The only other ID heading is column "B" which is "Employee Id"But
those
Please Help me on this _
On Jun 17, 2016 14:43, "vikas khen" wrote:
> Hi Team,
>
> Need your help on finding the value in attached sheet.
>
> Request all of you to kindly help me on this
>
> please find attached sheet for the reference.
>
> --
> Are you =EXP(E:RT) or
Since I don't know anything about your workbook or the types of values, I'd
suggest something like what follows.I've run into issues where Excel doesn't
treat a "null" value and a "blank/empty" cell as the same.Plus, when using
something like: wshD.Cells(r, "C")the "default" property is
Hi All,
Expecting your valuable reply on this _
Regards,
V!kas
On Dec 3, 2015 12:32 AM, "vikas khen" wrote:
> Hello Everyone,
>
> Please find the above attached sheet in which i need your help on the
> below said points.
>
> 1) When i click on date the Date-picker should be
>
> Here is attached two files , install the addin windatepicker.xlam first
>> and then run that Att file, Double click on date which u want to select.
>
>
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
Thank you DP!
Thank you very much for your help. It worked perfectly.
However, I tried to do the same in Calculation2 sheet, but inserting rows
instead of columns and it did not work the same logic. It gives me a syntax
error.
Could you help me fix this?
I used:
Dim v As Integer
v =
Hi Isabel,
I'am glad that its work, ok here is the problem in out 2nd case
1st, we need to step back to learn about how the function work,
cpearson.com have a bunch article about this complete with explanation &
sample, you can follow this link
Thank you DP
Your explanation was extraordinary. In addition to solve my problem, you taught
me a lot! ;)
Thank you very much again
Regards
Isabel
On Monday, September 14, 2015 at 7:37:57 PM UTC-5, De Premor wrote:
>
> Hi Isabel,
>
> I'am glad that its work, ok here is the problem in out 2nd
Hello Ashish,
Thank you for your response.
This is a simplified copy of my macro. The lines you can find there are
repeated
multiple times in my final workbook, in different spreadsheets because it
has a broader mathematical formulation.
Hope this helps,
Regards
On Saturday, September 12,
We can avoid using loop in this case, try to replace your looping code
with offset and resize, try this another solution
Dim u As Integer
u = Range("Months").Value - 1
If u > 1 Then
Range("ColumnLong").Resize(, u).Insert
Range("ColumnFormula").Copy
Range("ColumnLong").Offset(,
Can u pls share a sample file
On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote:
> Thank you Basole for your message!
> I have been already using your recommendation on my code, but it still
> takes a lot of memory.
>
> Regards,
> Isabel
>
>
>
> On Saturday, September 12,
Thank you Basole for your message!
I have been already using your recommendation on my code, but it still
takes a lot of memory.
Regards,
Isabel
On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote:
>
> Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
>
Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
the start of code. and "Application.Calculation = xlCalculationManual" To
turn off the automatic calculation
at the beginning of the code
see example:
Dim u As Integer, v As Integer
u = Range("Months").Value - 1
:
*To:* excel-...@googlegroups.com javascript:
*Sent:* Wednesday, August 5, 2015 7:34 AM
*Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in
the last
KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084
This secure message was sent using Dmail
What type of solution are you looking for?VBA macros? Excel function?Manual
steps?
how often do you need to do this?(is it a one-time thing, or
daily/weekly/monthly?)
What is the source of the data?Can you provide delimiters in the output?
Paul-
“Do all
@googlegroups.com
Sent: Wednesday, August 5, 2015 7:21 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
What type of solution are you looking for?VBA macros? Excel function?Manual
steps?
how often do you need to do this?(is it a one-time thing, or
daily/weekly
: $$Excel-Macros$$ Need help to split numbers available in
the last
What type of solution are you looking for?
VBA macros?
Excel function?
Manual steps?
how often do you need to do this?
(is it a one-time thing, or daily/weekly/monthly?)
What is the source of the data?
Can you provide
-
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, August 5, 2015 7:24 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
For MOST of the data, you could use an excel function
-
From: Nasir Shaikh nasirsa...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 5, 2015 7:34 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af
*To:* excel-macros@googlegroups.com
*Sent:* Wednesday, August 5, 2015 7:34 AM
*Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in
the last
KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084
This secure message was sent using Dmail
, August 5, 2015 7:34 AM
*Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in
the last
KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084
This secure message was sent using Dmail. To view this message, simply
click the button below
Hi,
Sub CommandButton_Click()
Dim i As Long
For i = 1 To Range(K65000).End(xlUp).Row
If Trim(Range(K i).Text) = Empty Then
Range(L i).Cut
Range(P i).Select
ActiveSheet.Paste
End If
Next I
End Sub
On Saturday, January 10, 2015 at 2:00:54 PM UTC+5:30, Vabz
Hi
Try below code..
Sub blah()
Dim fRow As Range, lRow As Range, rRange As Range
Dim c As Range
Set fRow = Range(K2)
Set lRow = Range(K Rows.Count).End(3)
Debug.Print lRow.Row
Set rRange = Range(fRow.Address : lRow.Address)
Debug.Print rRange.Address
For Each c In rRange
If IsEmpty(c) Then
Hi
You can do it using function sumifs
Share sample data in excel sheet if you need further help..
Cheers!!
ᐧ
On Fri, Jan 9, 2015 at 7:39 PM, Janani Rajagopalan uthr...@gmail.com
wrote:
I have the below data. I want to dynamically sum the Value column when the
CID and FID are the same and
hi
you are trying ti print payslip?
Check my last email where i have given you solution to it..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 26, 2014 at 11:49 PM, M.Rafique MRU imrafiqu...@gmail.com
wrote:
Dear Experts!
I am facing
hi
what is WID..
if you want to file Apr-Mar below then select range B2:B13, after that
using mouse take your cursor to bottom end of right side till it becomes
dark black plus sign then double click on it,.
+
*I did not do this for you. God is here working through me for you.*
On Wed,
Check this...
is this what you are looking for?
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 3:38 PM, Vaibhav Joshi v...@vabs.in wrote:
hi
what is WID..
if you want to file Apr-Mar below then select range B2:B13, after that
using
hi,
WIid is Whole seller unique id and i have to reflect total months from
april to march individully based on WID
so kidnly help me
On 24 December 2014 at 15:38, Vaibhav Joshi v...@vabs.in wrote:
hi
what is WID..
if you want to file Apr-Mar below then select range B2:B13, after that
try this
=TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),)
On Wed, Dec 24, 2014 at 3:46 PM, Raj Kumar rajlu...@gmail.com wrote:
hi,
WIid is Whole seller unique id and i have to reflect total months from
april to march individully based on WID
so kidnly help me
On 24 December 2014 at 15:38,
Try formula given by Ashish Koul, its working great!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 3:55 PM, ashish koul koul.ash...@gmail.com wrote:
try this
=TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),)
On Wed, Dec 24, 2014 at 3:46
Vabz...Thank you very much for the explanation and fix...it works...
Rob
On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote:
hi
You will get error if no value is added in list box.
add line on error resume next in beginning to avoid this error..
cheers
+
*I did not do
cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 11:09 PM, Rob Flott robfl...@gmail.com wrote:
Vabz...Thank you very much for the explanation and fix...it works...
Rob
On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote:
hi
hi
You will get error if no value is added in list box.
add line on error resume next in beginning to avoid this error..
cheers
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott robfl...@gmail.com wrote:
On a worksheet I
hi experts pls convert to vba macro
mmc input text box
mnc input text box
lac input text box
cid input text box
button
below code
table width=450
trtd
/td/tr
/table
form method=post action=?php echo $PHP_SELF;?
table
tr
tda
Hi
pl share us code in proper html file format instead of this code..
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 1, 2014 at 1:36 PM, my excel myxlg...@gmail.com wrote:
hi experts pls convert to vba macro
mmc input text box
mnc input text box
Guruji,
please send to my email id only html php in attached file
it's my request
thank you
using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
using System.Diagnostics;
/*
* Sample code to obtain geo codes from a cell info
* GSM/UMTS setting
hi
you can use following line in stead of yours
ieobj2.getlementbyid(cmdclose).click
IE.document.all.Item
Call IE.document.parentWindow.execScript(javafunction(), JavaScript)
in above secone line replace javafunction with a function which is
called by your webpage on clicking ok button...
hope
Hi Ravi/Vaibhav
its not working at all..
i hv button from ASP
that ieobj2.getlementbyid(cmdclose).click
once i click it generate alert..and my code stops debugging next, aleart is
do u really want to close this.. i hv to click on ok button please siggest
me further solution
On Fri, Nov 28,
Hi
Can you share url of webpage which you are acessing..
On Nov 30, 2014 12:29 AM, Sunil Patil sunil.patil...@gmail.com wrote:
Hi Ravi/Vaibhav
its not working at all..
i hv button from ASP
that ieobj2.getlementbyid(cmdclose).click
once i click it generate alert..and my code stops
Hi,
Add below line in your code. Might be it works
webbrowser.Silent = True
‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use
ie instead of ‘webbrowse’
Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com
hi
you can try adding either of foll lines...
Application.SendKeys({enter})
or
Application.SendKeys(~)
however its always not the same thing what we percieve, if it doent work pl
share ur code to chek further...
Cheers!!
+
*I did not do this for you. God is here working through me for
Hi Chandru,
PFA
Regards
Ashish
On 24 November 2014 at 11:57, Chandru chandr...@gmail.com wrote:
I need Excel formula or VBA for the following.
*) To set cell width(for headers).
*) To make hyper link text blue.
*) Font Formatting(for headers).
Regards,
Chandru
--
Are you
Used this Formula in D2 and drag down. .
=SUBSTITUTE(A2, ,)
Cheers
On Nov 16, 2014 9:32 AM, Imran Khan ikha...@gmail.com wrote:
To All:-
PLease help me to provide formula to eliminate the space. Example file
attached.
Regards,
*Imran Khan*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Hi Ashish,
I am sorry I was not clear in my email.
Let me clarify.
Cell A1 has a drop down list (Global, Local)
If someone selects Global, Cell B1 should show a drop-down list which is
coming through a named range. I have that assigned.
But, if the user selects Local, the Cell B1 should not
Hi Sharath,
PFA..!
Change your data in A1. If you select Global in A1 then drop down list will
show in B1 and If you select Local in A1 then drop down list will be
deleted in B1. you are able to write anything in B1
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Thanks Ashish,
This is exactly what I wanted!
Regards,
Sharath
On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Sharath,
PFA..!
Change your data in A1. If you select Global in A1 then drop down list
will show in B1 and If you select Local in A1 then
Welcome Sharath.
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, like
Opening a file to show form.
To import the data: Typing data into the form and click the Data Entry
To edit data:Click listbox to select data, The data will appear on the
form, Edit the data needed, and click Edit Data.
2014-11-12 13:34 GMT+07:00 Kamal Ganeshan ganesh.theva...@gmail.com:
Great one buddy!
On Nov 13, 2014 4:13 AM, Bé Trần Văn betnmtdongna...@gmail.com wrote:
Opening a file to show form.
To import the data: Typing data into the form and click the Data Entry
To edit data:Click listbox to select data, The data will appear on the
form, Edit the data needed, and
Hi All,
I want you to understand the requirements.
Sub Brand numbers Invoice number combination will be multiple.
Can anyone will be help me out to create a user form.
for eg:
Brand numbers Invoice numbersStatus
90121 97012
Hi Vaibhav Bhai,
Sheet is working fine. Superb!
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
Hi Vaibhav Bhai,
Working Perfectly. Thanks...
Superb...!! You are amazing
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES, SAVE EARTH” *
*“All appears to change when we change!”*
On 28 October 2014 11:38,
1 - 100 of 656 matches
Mail list logo