Microsoft Excel Programming

Sort by: Replies Descending

J

Force Caps Lock

John
May 25, 2004

2

Replies: 23

Views: 2K

Jun 1, 2004

David McRitchie

D

J

Filtering info to corresponding sheet

JC
Jul 13, 2009

2

Replies: 23

Views: 765

Aug 14, 2009

Ron de Bruin

R

L

When found add it to the last and display total in Msgbox

L. Howard
Sep 13, 2014

2

Replies: 23

Views: 1K

Sep 15, 2014

Claus Busch

C

G

separate text into two columns

gwbdirect
Feb 4, 2009

2

Replies: 23

Views: 952

Feb 19, 2009

Ron Rosenfeld

R

O

Pivot Table - change page field help

Opal
Mar 10, 2009

2

Replies: 23

Views: 1K

Mar 16, 2009

Opal

O

G

Copy latest date from one workbook to another

Guest
Sep 8, 2006

2

Replies: 23

Views: 791

Sep 21, 2006

Guest

G

G

getting worksheetnames as links.

Guest
Mar 14, 2007

2

Replies: 23

Views: 838

Mar 27, 2007

Guest

G

G

Issue with Sort

Guest
Jun 5, 2007

2

Replies: 23

Views: 599

Jun 6, 2007

Guest

G

P

Change Empty Cells Font for the Entire Workbook

Paul Black
Sep 9, 2004

2

Replies: 23

Views: 1K

Sep 15, 2004

Peter T

P

B

Formulas containing hard coded values

Bony Pony
Aug 4, 2009

2

Replies: 23

Views: 1K

Aug 7, 2009

Rick Rothstein

R

E

Method 'Range' of Object_Worksheet Failed

Excel-erate2004
Aug 29, 2004

2

Replies: 23

Views: 2K

Sep 2, 2004

Tom Ogilvy

T

J

Ignorance is not bliss

Jaybird
May 5, 2008

2

Replies: 23

Views: 931

May 8, 2008

Jaybird

J

G

Dynamic Creation of Invoice number

Guest
Oct 9, 2006

2

Replies: 23

Views: 926

Oct 12, 2006

Guest

G

S

Right() error changing columns in macro

S Himmelrich
Dec 12, 2007

2

Replies: 23

Views: 602

Dec 13, 2007

SeanC UK

S

Y

Bias in rand for excel 07

yttrias
Dec 16, 2007

2

Replies: 23

Views: 3K

Dec 21, 2007

yttrias

Y

G

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

George
Nov 3, 2006

2

Replies: 23

Views: 864

Nov 7, 2006

George

G

A

Ams
Jan 14, 2008

2

Replies: 23

Views: 867

Jan 27, 2008

Ams

A

B

Public Variable dilemma

Brettjg
Apr 23, 2009

2

Replies: 23

Views: 1K

Apr 25, 2009

Brett

B

S

SumIf using two criteria

SA3214
Mar 30, 2005

2

Replies: 23

Views: 1K

Mar 31, 2005

Bob Phillips

B

T

Command Button Naming

Tanya
Nov 27, 2007

2

Replies: 23

Views: 986

Dec 5, 2007

Tanya

T

G

Guest
Sep 7, 2007

2

Replies: 23

Views: 743

Sep 14, 2007

Guest

G

R

How can I time the speed of a macro?

RyanH
Sep 9, 2008

2

Replies: 23

Views: 904

Sep 10, 2008

Bernd P

B

S

Who or What is Tom Ogilvy?

Stella
Jul 18, 2006

2

Replies: 23

Views: 1K

Jul 22, 2006

via135

V

I

empty cell instead of 0's

ims121uk
Sep 14, 2006

2

Replies: 23

Views: 911

Sep 18, 2006

[email protected]

I

J

Opening a file through input of first 3 digits

Just4fun
Jun 26, 2004

2

Replies: 23

Views: 769

Jun 26, 2004

Tom Ogilvy

T

P

Recursive Function + File searching to return path

ph8
Jul 14, 2005

2

Replies: 23

Views: 1K

Oct 14, 2005

ph8

P

G

Help with Visual Basic for Excel

Guest
Feb 15, 2006

2

Replies: 23

Views: 798

Feb 27, 2006

Guest

G

K

Before Print Problem

Karen53
Jan 25, 2008

2

Replies: 23

Views: 829

Jan 28, 2008

Dave Peterson

D

C

Macro to only allow pasting of values and not format??

Celt
Mar 17, 2006

2

Replies: 23

Views: 3K

Apr 3, 2006

ben

B

G

Capital Letters

Guest
Mar 16, 2005

2

Replies: 23

Views: 1K

Mar 24, 2005

Peter T

P

L

Calculate the number of days between two dates

Luca Villa
Nov 10, 2007

2

Replies: 23

Views: 1K

Nov 13, 2007

Luca Villa

L

M

Reference named range in closed workbook

metricsinstitute
Apr 22, 2014

2

Replies: 23

Views: 3K

May 17, 2014

GS

G

K

File creation wait timer

Ken
Sep 12, 2009

2

Replies: 23

Views: 1K

Sep 14, 2009

Ken

K

P

Can this Code be Condensed

Paul Black
Nov 12, 2007

2

Replies: 23

Views: 817

Nov 21, 2007

Guest

G

S

Way to only import new files?

shikamikamoomoo
Mar 23, 2006

2

Replies: 22

Views: 763

Mar 29, 2006

shikamikamoomoo

S

H

hide rows with macro/togglebutton

huntermcg
Sep 21, 2005

2

Replies: 22

Views: 1K

Oct 14, 2005

huntermcg

H

S

Save to hard drive and backup to thumb drive.

sungen99
Jan 24, 2006

2

Replies: 22

Views: 754

Jan 27, 2006

sungen99

S

L

Validating Dates

Luis Verme
Jul 6, 2005

2

Replies: 22

Views: 845

Jul 10, 2005

JE McGimpsey

J

G

Calculating subtotals

gary
Feb 12, 2012

2

Replies: 22

Views: 2K

Feb 21, 2012

gary

G

M

color row using macro..

marc747
Jun 21, 2008

2

Replies: 22

Views: 1K

Jul 17, 2008

j j

J

G

Userform combo box

Guest
Apr 27, 2006

2

Replies: 22

Views: 879

Oct 6, 2009

Dave Peterson

D

E

How can I clean the buffer from the folder picker?

Excel 009
Sep 27, 2006

2

Replies: 22

Views: 886

Oct 3, 2006

Excel 009

E

G

VBA text to columns

Guest
May 17, 2007

2

Replies: 22

Views: 1K

May 20, 2007

Dave Peterson

D

G

help to a very special split

Guest
Apr 22, 2006

2

Replies: 22

Views: 680

Apr 23, 2006

Guest

G

W

Can .FindNext return Nothing??

Wild Bill
Apr 29, 2005

2

Replies: 22

Views: 970

Apr 30, 2005

Zack Barresse

Z

P

Macro runs fine from VBEditor, but not button

pickytweety
Feb 22, 2010

2

Replies: 22

Views: 2K

Feb 25, 2010

Dave Peterson

D

L

If ActiveCell has a comment then exit sub

L. Howard
Jan 13, 2015

2

Replies: 22

Views: 2K

Jan 14, 2015

GS

G

D

Date manipulation within text entries

David
Mar 18, 2005

2

Replies: 22

Views: 896

Mar 19, 2005

David

D

R

For Next loop faster with counter after Next?

RB Smissaert
Aug 27, 2006

2

Replies: 22

Views: 958

Aug 28, 2006

RB Smissaert

R

M

Conditional Borders through a Macro

MSchmidty2
Jun 24, 2008

2

Replies: 22

Views: 865

Oct 3, 2008

Rick Rothstein

R