Microsoft Excel Programming

Sort by: Replies Descending

G

Use a Piece of Data for File Name

Guest
Sep 26, 2007

2

Replies: 25

Views: 713

Sep 27, 2007

RB Smissaert

R

K

(in)definite article and leading/trailing space remover needed

KHashmi316
Jun 14, 2005

2

Replies: 25

Views: 1K

Jun 16, 2005

KHashmi316

K

T

Pop-up Message on error

TomBP
Jul 24, 2006

2

Replies: 25

Views: 902

Jul 27, 2006

TomBP

T

H

Pass array of worksheets to ActiveX DLL (VB6)

Hank Scorpio
Jun 17, 2004

2

Replies: 25

Views: 2K

Jun 21, 2004

Stephen Bullen

S

C

First Time VBA user- really easy question :-)

cappy2112
Jun 18, 2007

2

Replies: 25

Views: 1K

Jun 19, 2007

Dave Peterson

D

C

Carlton Patterson
Jun 26, 2005

2

Replies: 25

Views: 936

Jun 27, 2005

Carlton Patterson

C

M

Get info from changing cell to a static cell ??

Maxibo
Dec 16, 2005

2

Replies: 25

Views: 676

Dec 17, 2005

Ken Johnson

K

C

Input Box selection and file open

cottage6
Mar 26, 2008

2

Replies: 25

Views: 847

Apr 2, 2008

Rick Rothstein \(MVP - VB\)

R

G

delete all blank rows in a spreadsheet

Guest
May 26, 2006

2

Replies: 25

Views: 983

May 27, 2006

Nigel

N

M

Macros & alternatives

Mangesh Yadav
Jul 19, 2005

2

Replies: 25

Views: 1K

Jul 20, 2005

Mangesh Yadav

M

G

Guest
Nov 30, 2005

2

Replies: 25

Views: 1K

Nov 30, 2005

Bob Phillips

B

D

Extract 5 digit number from string

directos2
Apr 14, 2007

2

Replies: 24

Views: 2K

Apr 15, 2007

Ron Rosenfeld

R

S

Steve
Jul 9, 2009

2

Replies: 24

Views: 1K

Jul 9, 2009

Steve

S

G

Guest
Mar 8, 2007

2

Replies: 24

Views: 1K

Mar 13, 2007

Dave Peterson

D

S

convert hyperlink to email address

Seemore
Jan 29, 2008

2

Replies: 24

Views: 1K

Aug 7, 2008

Sheri Contino

S

J

MsgBox that will open only once.

John
Jan 8, 2010

2

Replies: 24

Views: 4K

Jan 8, 2010

John

J

M

List Box Columns

Mark
Aug 12, 2008

2

Replies: 24

Views: 741

Aug 24, 2008

Dave Peterson

D

N

Opening/Closing Large Files

Nigel
Jan 24, 2008

2

Replies: 24

Views: 872

Jan 30, 2008

Brouws

B

P

.XLA: Making it an AddIn vs adding a Reference?

PeteCresswell
May 30, 2008

2

Replies: 24

Views: 1K

Jun 2, 2008

Jon Peltier

J

A

Al_82
Sep 22, 2009

2

Replies: 24

Views: 1K

Sep 25, 2009

Jacob Skaria

J

S

scottnshelly
Mar 19, 2004

2

Replies: 24

Views: 1K

Mar 31, 2004

Charles

C

M

Max
Dec 31, 2009

2

Replies: 24

Views: 1K

Jan 5, 2010

Max

M

M

Grabbing string values from the end of a string of an unknown length

Mark Stephens
Jul 7, 2008

2

Replies: 24

Views: 1K

Jul 8, 2008

Mark Stephens

M

W

Range holding non-contiguous cells

William Benson
Jul 26, 2005

2

Replies: 24

Views: 2K

Jul 27, 2005

Peter T

P

C

vba help please

Coyote
Dec 30, 2004

2

Replies: 24

Views: 637

Jan 3, 2005

Guest

G

S

Search faster using array - But it slows down

Ste Mac
Oct 19, 2009

2

Replies: 24

Views: 1K

Oct 26, 2009

Charles Williams

C

T

VLOOKUP Insert & Copy

Ty
Aug 11, 2009

2

Replies: 24

Views: 1K

Aug 13, 2009

Ty

T

J

How to strore exact double from macro into Excel cell?

JoeU2004
Sep 23, 2009

2

Replies: 24

Views: 914

Oct 8, 2009

Jerry W. Lewis

J

G

vba code doesn't work

Guest
Jul 21, 2005

2

Replies: 24

Views: 1K

Jul 22, 2005

Tom Ogilvy

T

A

Copy range if column N is empty

ajm1949
May 11, 2010

2

Replies: 24

Views: 1K

May 13, 2010

Rick Rothstein

R

M

Change Colors With 5 Different Conditions

Minitman
Jul 25, 2005

2

Replies: 24

Views: 914

Jul 27, 2005

Minitman

M

M

Sub cannot run (Error 5)

Max
Dec 19, 2005

2

Replies: 24

Views: 880

Dec 20, 2005

Max

M

D

Proper way to write a conditional statement with ands

DKY
Jul 16, 2005

2

Replies: 24

Views: 640

Jul 18, 2005

DKY

D

H

VB macros in new Excel

Howard Brazee
Jan 4, 2010

2

Replies: 24

Views: 1K

Jan 4, 2010

Gord Dibben

G

R

Can this QuickSort work?

RB Smissaert
Jun 25, 2006

2

Replies: 24

Views: 900

Jun 27, 2006

Michael C

M

A

VBA Regular Expressions & URL Extraction

Akrobrat
Feb 6, 2009

2

Replies: 24

Views: 8K

Feb 17, 2009

Ron Rosenfeld

R

G

Zipping the current Excel Spreadsheet with PkZip

Guest
Dec 17, 2005

2

Replies: 24

Views: 1K

Nov 2, 2007

Ron de Bruin

R

G

Macro add Hyperlink formula

Guest
Sep 9, 2005

2

Replies: 24

Views: 820

Jan 13, 2009

Dave Peterson

D

G

runtime error 424

Guest
Jan 10, 2006

2

Replies: 24

Views: 1K

Jan 24, 2006

Dave Peterson

D

B

Precedents for formulas

Bob
Aug 29, 2008

2

Replies: 24

Views: 2K

Aug 30, 2008

Dave Peterson

D

J

convert a Word macro to an Excel macro

jsd219
Oct 23, 2006

2

Replies: 24

Views: 972

Oct 27, 2006

Dave Peterson

D

X

Fast code in 2003 = agonizingly slow code in 2007

XP
Oct 16, 2008

2

Replies: 24

Views: 981

Oct 21, 2008

XP

X

J

Workbook.activate acts dif when activewindow.caption changed

jc
Jun 12, 2008

2

Replies: 24

Views: 1K

Jun 17, 2008

jc

J

M

Reference named range in closed workbook

metricsinstitute
Apr 22, 2014

2

Replies: 23

Views: 3K

May 17, 2014

GS

G

G

update range in For loop

Guest
Apr 12, 2006

2

Replies: 23

Views: 681

Apr 17, 2006

Zack Barresse

Z

G

getting worksheetnames as links.

Guest
Mar 14, 2007

2

Replies: 23

Views: 838

Mar 27, 2007

Guest

G

K

Before Print Problem

Karen53
Jan 25, 2008

2

Replies: 23

Views: 829

Jan 28, 2008

Dave Peterson

D

J

Ignorance is not bliss

Jaybird
May 5, 2008

2

Replies: 23

Views: 931

May 8, 2008

Jaybird

J

T

Command Button Naming

Tanya
Nov 27, 2007

2

Replies: 23

Views: 986

Dec 5, 2007

Tanya

T

G

How to populate a summary page ????????????????????????????????????????

George
Nov 3, 2006

2

Replies: 23

Views: 864

Nov 7, 2006

George

G