Yes, can you pls suggest the alternative code.
Idea is when comboboxes are empty then it should run only on dates.
Cheers
Karthik
On Tuesday, 29 March 2016 20:01:03 UTC+5:30, Paul Schreiner wrote:
>
> Ah...
> I think maybe we should rethink the logic here.
> In your statement:
> Set rngD = w
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title : Senior Java Developer---** Must have LinkedIn profile*
*Location :San Francisco, CA *
*Duration :**5 months+*
*10+ years as a Java software engineer*
*Required Experience & Technical Requ
*Title : ServiceNow consultant. *
*Duration :Six months contract.*
*This is a C2H position. so need EAD,GC or USC.*
*Description *
*Key Roles & Responsibilities**:*
· Engage process owners and business stakeholders to translate
business requirements into feasible functional requir
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
* Title :Java/ J2EE Consultant ( EAD, GC, USC ) 9 month Contract Eden
Prairie, MN—F@F must*
Multiple Positions
*Candidates must have experience with Java, REST, Spock, and Groovy!*
*Requirements:*
•
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title :Senior Filenet Architect -Hartford CT Location: Hartford ,CT**Need
GC or citizens *
*Job Type:* FTE or C2H
*Should be open to relocate or travel at customer location*
*Description*
·
Ah... I think maybe we should rethink the logic here.In your statement:Set
rngD = wshD.Range("G:G").Find(What:=Me.ComboBox1.Value, Lookat:=xlWhole)if
Me.ComboBox1.Value is empty, you're looking in column G for "nothing".Does the
.Find method return an empty range? or a range of which column G i
Thanks Paul for your response.Here is the complete macro for better
understanding.
Sub Fetch_Click()
Dim wshD As Worksheet
Dim wshP As Worksheet
Dim rngD As Range
Dim rngP As Range
Dim r As Long
Dim m As Long
Dim n As Integer
Dim rngD2 As Range
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 "value",
Where did the .msg files come from?By looking online, it sounds like .msg files
COULD be:
MSG is a file extension for a mail message file format used by Microsoft
Outlook and Exchange.
An MSG file can contain plain ASCII text for the headers and the main message
body as well as hyperlinks and
Mr. Shot: :)
I don't believe you're being "ignored".I suspect it's more along the lines
of:"How much effort do I/we have to put into trying to figure out what it is
you want to do and do I/we have the expertise to address it".
Your messages are a "little" confusing.
You've posted a question on an
Hi Guys,
Still waiting for some resolution in this group.
Pls help.
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment and send that mail to a particular distor
> list
http://www.techrepublic.com/blog/windows-and-office/excels-auto-outline-quickly-hides-data-details-to-simplify-viewing/
go to the above url or watch the following url on youtube
https://www.youtube.com/watch?v=8j6KX6WDgEM
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Dear All,
I have the below macro in excel which opens and takes print of a word file
saved in a folder. In the same way i need to print .msg file saved in a
folder, could you please guide me how to edit the macro to do the same.
I am using Excel 2016. Appreciate if anybody could help me on this.
Hello,
I have formulated a macro to search data, from a worksheet, using user
forms. User form has Date picker and couple of comboxes. Idea is to search
between two dates along with two criterias.
My problem is, macro doesnt function if I do not enter all the search
criterias. Ideally, it sh
14 matches
Mail list logo
