# Search:

Type: Posts; User: dguillett@gmail.com; Keyword(s):

Page 1 of 5 1

1. ## Thread: WLM Windows Live Mail Duplicates Prevent and remove existing GMAIL

by dguillett@gmail.com
Replies
1
Views
29

### WLM Windows Live Mail Duplicates Prevent and remove existing GMAIL

As the subject says., I have duplicates created in my inbox that I want to prevent and delete the existing. Assistance appreciated

I have 3 Gmail accounts that I read in WLM

by dguillett@gmail.com
Replies
3
Views
72

### http://www.ibm.com/us/en/ use this...

http://www.ibm.com/us/en/
use this
=IF(ISERROR(FIND("//www.",J3)), MID(J3,FIND(":",J3,4)+3,FIND("/",J3,9)-FIND(":",J3,4)-3), MID(J3,FIND(":",J3,4)+7,FIND("/",J3,9)-FIND(":",J3,4)-7))
to get...
3. ## Thread: Excel files--how big is too big?

by dguillett@gmail.com
Replies
7
Views
141

### convert formulas that are no longer needed to...

convert formulas that are no longer needed to values

by dguillett@gmail.com
Replies
7
Views
290

### To do an entire range using the function Sub...

To do an entire range using the function

Sub fixphonerange()
Dim c As Range
Dim num As Range
For Each c In Range("E1:e15")
c = pn(c)
Next
End Sub

by dguillett@gmail.com
Replies
7
Views
290

### Try this instead Function pn(Num) As String Dim...

Function pn(Num) As String
Dim i As Integer
For i = 1 To Len(Num)
If Asc(Mid(Num, i, 1)) >= Asc("0") _
And Asc(Mid(Num, i, 1)) <= Asc("9") Then
pn = pn + Mid(Num,...
6. ## Thread: Macro to auto increment filename in FileToOpen

by dguillett@gmail.com
Replies
8
Views
214

7. ## Thread: Lotus 1 2 3 opening Problem

by dguillett@gmail.com
Replies
2
Views
103

### You are opening 123 files (which version) in what...

You are opening 123 files (which version) in what version_______ of _________________? If desired send the file directly to me. dguillett @gmail.com
8. ## Thread: Macro to auto increment filename in FileToOpen

by dguillett@gmail.com
Replies
8
Views
214

### Look here...

Look here
http://www.rondebruin.nl/win/s3/win008.htm
for
Merge a range from all workbooks in a folder (below each other)
9. ## Thread: Highlight specific text in a search

by dguillett@gmail.com
Replies
9
Views
330

### Nicely done. Only comment is use native instr...

Nicely done. Only comment is use native instr instead of application.find
InStr(zRng, ztext)
10. ## Thread: Converting numerical cell value to absolute or negative/positive

by dguillett@gmail.com
Replies
7
Views
508

### Although I am using my chase account to just park...

Although I am using my chase account to just park some money due to a promotion and have NO negatives, I did download the csv> put in a - in front of and entry and ran this one liner to remove the -...
11. ## Thread: Excel 2013 Opens 2 windows

by dguillett@gmail.com
Replies
1
Views
101

### Here is a desktop shortcut I have to open a file...

Here is a desktop shortcut I have to open a file with 2013 that doesn't do that
target
C:\Program Files (x86)\Microsoft Office 2010\Office15\EXCEL.EXE" "c:\personal\myfilenamehere.xls"
startin...
12. ## Thread: Move to multiple rows and copy adjacent cell down

by dguillett@gmail.com
Replies
2
Views
131

### 'Could be better but works Option Explicit...

'Could be better but works

Option Explicit
Sub LineEmUpSAS()
Dim i As Long
Application.ScreenUpdating = 0
i = 1
Do Until IsEmpty(Cells(i, 1))
If Len(Application.Trim(Cells(i, 4))) <> 0 Then...
13. ## Thread: Arrange Web Imported Data Horizontally Excel 2007

by dguillett@gmail.com
Replies
5
Views
235

### Option Explicit Sub TransposeSAS() Dim c As...

Option Explicit
Sub TransposeSAS()
Dim c As Integer
Dim lc As Integer
Dim i As Long

With ActiveSheet
.Columns.ClearContents
For c = 1 To 3
lc = Cells(1,...
14. ## Thread: Macro to open Files

by dguillett@gmail.com
Replies
7
Views
191

### And set wbdata= should not be necessary

And set wbdata= should not be necessary
15. ## Thread: Arrange Web Imported Data Horizontally Excel 2007

by dguillett@gmail.com
Replies
5
Views
235

### To avoid leaving a formula or formula=value just...

To avoid leaving a formula or formula=value just use
Range("A" & Row & ":C" & Row).value=application.transpose(etc).value
16. ## Thread: Posting a row of Data Into Range until full

by dguillett@gmail.com
Replies
6
Views
249

### Thanks, I usually try to avoid all selections...

Thanks, I usually try to avoid all selections and copy/pastes where possible
17. ## Thread: Macro to open Files

by dguillett@gmail.com
Replies
7
Views
191

### The error is not that. It will run with/without...

The error is not that.
It will run with/without the set wbData=
It will run with/without the wbData=

The problem is that the macro is asking for .xls files to open and the list has the...
18. ## Thread: Posting a row of Data Into Range until full

by dguillett@gmail.com
Replies
6
Views
249

### I always thought selections should be avoided...

I always thought selections should be avoided where possible?

'COPY DAY ROW TO BOTH SHEETS
week.Range("B" & weekRow).Resize(, 50).Value = _
day.Cells(51, 2).Resize(, 50).Value...
19. ## Thread: Merged Cells causing issues

by dguillett@gmail.com
Replies
4
Views
222

### I stand corrected IF the header part was needed....

I stand corrected IF the header part was needed. As I understood (not well explained) OP just wanted to get info from the file and not to make it pretty.
We should always be trying to improve our...
20. ## Thread: Merged Cells causing issues

by dguillett@gmail.com
Replies
4
Views
222

### If that is the need then this should be a bit...

If that is the need then this should be a bit more efficient

Option Explicit
Sub UnmergeCellsSAS()
Dim fr As Long
Dim lr As Long
Application.ScreenUpdating = 0...
21. ## Thread: Divide into Group

by dguillett@gmail.com
Replies
9
Views
369

### provide sample FILE with before/after

provide sample FILE with before/after
22. ## Thread: macro text box for opening 4 digit file number

by dguillett@gmail.com
Replies
35
Views
848

Homework?
23. ## Thread: Vlookups, IF, Match and Index query

by dguillett@gmail.com
Replies
11
Views
456

### IF you change the format of your v10:z10 from...

IF you change the format of your v10:z10 from MERGE to CENTER ACROSS and use the formula, AS WRITTEN, and then apply the CSE it works just fine for the parameters given........
See attached.
24. ## Thread: Vlookups, IF, Match and Index query

by dguillett@gmail.com
Replies
11
Views
456

### Please tell us WHY it didn't work and what more...

Please tell us WHY it didn't work and what more you expect it to do????? A larger sample might be good or the ACTUAL file.
25. ## Thread: Macro to copy data from one folder to another

by dguillett@gmail.com
Replies
2
Views
135

### http://www.rondebruin.nl/win/s3/win026.htm

http://www.rondebruin.nl/win/s3/win026.htm
Results 1 to 25 of 122
Page 1 of 5 1