Re: Accessing Values from Names Manager
Hi Mackeral...
Perhaps
QuoteTS = Range("Name_to_Lookup").Value
Re: Accessing Values from Names Manager
Hi Mackeral...
Perhaps
QuoteTS = Range("Name_to_Lookup").Value
Re: Help needed to modify the following code so that the data is copied only once.
Hi raghuprabhu
Welcome to the Forum!!
Replace your LoopThroughDirectory Code with this...
Re: Accumulate count of Combobox selections
Hi zey67
List Boxes can be Multi Select...however, I don't see how that fills your need...
Re: Accumulate count of Combobox selections
Hi zey67
Far as I know you cannot have multiple selections in your Combo Boxes.
Re: Accumulate count of Combobox selections
Hi zey67
All of your 10 Combo Boxes are linked to the same Cell (M1) and, accordingly, will assume that value...
Re: help with send an Email with Excel VBA Code
Hi pacedove
Welcome to the Forum!!!
Try this Code...
Re: VBA to delete entire row if cell matches the exact whole word
Hi CodeNerd
Please include your existing Code in your Sample File. Please make sure the Structure of your Sample File is of the same Structure as your Actual File. Please include a Worksheet that demonstrates your expected results.
Re: VBA to delete entire row if cell matches the exact whole word
Well, you could change xlPart to xlWhole...a Sample File would be good so we can help you debug.
Re: VBA to delete entire row if cell matches the exact whole word
Hi CodeNerd
Perhaps remove the Wildcard from in front of *test* becoming test*
Re: Delete entire row if a cell does not match the keyword/data
Hi Jomz07
Yes, this is correct...
Quoteif I change Field:=6 to, let's say 3, would that be filtering column 3?
However, if your Filter Range reads like this Column C would be 2...
Further, if it reads like this Column C would be 1...
Re: find rows and replace each with several rows
You're welcome...glad I could help.
Re: find rows and replace each with several rows
Hi catcat111
As I understand your requirements, this Code in the attached appears to do as you suggested...let me know...
Re: Delete entire row if a cell does not match the keyword/data
Hi Jomz07
Welcome to the Forum!!!
Try this Code in a General Module...
Re: Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet
Hi Chris
There is no closing "TABLE" line on this "DOC" record...why? This is the cause of the failure...it's not consistent...
Excel 2007 32 bit
[TABLE="class: head"]
[TR="bgcolor: #888888"]
[TH][/TH]
[TH]
A
[/TH]
[TH]
B
[/TH]
[TH]
C
[/TH]
[TH]
D
[/TH]
[TH]
E
[/TH]
[TH]
F
[/TH]
[TH]
G
[/TH]
[TH]
H
[/TH]
[TH]
I
[/TH]
[TH]
J
[/TH]
[TH]
K
[/TH]
[TH]
L
[/TH]
[TH]
M
[/TH]
[TH]
N
[/TH]
[TH]
O
[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
336
[/TD]
DOC
[/td]
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
337
[/TD]
ID
SUF
TIV-11
TIV-12
TIV-13
TIV-14
TIV-15
TIV-16
TIV-17
TIV-18
TIV-19
TIV-22
TIV-24
TIV-25
TIV-26
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
338
[/TD]
H42K-BBR-004
F
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
339
[/TD]
H42K-BBR-004
G
[/td]
[/td]
[/td]
[/td]
Yes
[/td]
[/td]
Yes
[/td]
Yes
[/td]
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
340
[/TD]
H42K-BBR-004
P
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
341
[/TD]
H42K-BBR-004
J
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
342
[/TD]
H42K-BBR-004
J
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
343
[/TD]
H42K-BBR-004
J
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
Yes
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
344
[/TD]
H42K-BBR-004
J
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
345
[/TD]
H42K-BBR-004
J
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
346
[/TD]
H42K-BBR-004
J
[/td]
Yes
[/td]
[/td]
Yes
Yes
[/td]
Yes
[/td]
Yes
Yes
[/td]
Yes
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
347
[/TD]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
348
[/TD]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
349
[/TD]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
350
[/TD]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
351
[/TD]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/td]
[/TR]
[/TABLE]
[TABLE="class: grid"]
Sheet: Sheet1
[/td]
[/TABLE]
Re: Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet
Something is different. I'll look at it in the AM.
Re: Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet
Hi Chris
Here's the Annotated Code...something makes no sense let me know...
Re: Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet
Hi Chris
Glad you like it...thanks for the Rep.
I'll comment the Code and repost it. With regard to the Columns and mixed Content, how many unique "TIV" numbers are there and what are they?