Microsoft Excel Programming

Sort by: Replies Descending

N

Calculate actual trunk utilization based on call start/duration

nathaniel.watkins
Mar 29, 2008

2

Replies: 27

Views: 3K

Feb 21, 2010

Gord Dibben

G

J

How do I prevent AutoRun Macros when Programmatically Opening Workbook?

Joseph Geretz
Mar 26, 2006

2

Replies: 27

Views: 10K

Mar 26, 2006

Peter T

P

R

Spliting digits up to fit paper form

Revenue
Aug 23, 2011

2

Replies: 27

Views: 1K

Aug 25, 2011

GS

G

D

Access to this newsgroup

Dean
Sep 9, 2006

2

Replies: 27

Views: 795

Sep 15, 2006

Don Guillett

D

F

When do you need .Value?

Fred Smith
May 15, 2004

2

Replies: 27

Views: 704

May 27, 2004

xtb

X

G

Re-Post: Before_Print Sub Doesn't Trigger

Guest
Feb 28, 2004

2

Replies: 27

Views: 1K

Mar 4, 2004

Tom Ogilvy

T

H

Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet

Howard
Sep 28, 2013

2

Replies: 27

Views: 1K

Sep 29, 2013

GS

G

P

Unique Random Numbers

Paul Black
Sep 8, 2011

2

Replies: 27

Views: 2K

Sep 11, 2011

joeu2004

J

L

Problem with a loop and column references

L. Howard
Dec 4, 2014

2

Replies: 27

Views: 2K

Dec 4, 2014

L. Howard

L

H

Geting around XIRR error

Howard Kaikow
May 1, 2008

2

Replies: 27

Views: 1K

May 15, 2008

Howard Kaikow

H

G

Searching for Capital Letters

Guest
Sep 28, 2006

2

Replies: 27

Views: 1K

Oct 1, 2006

Leo Heuser

L

D

Recalculate cell #2

Dennis Allen
Sep 13, 2004

2

Replies: 27

Views: 1K

Sep 17, 2004

Dennis Allen

D

C

VBA color picker - copy of Font dialog combo box

csugden
Nov 24, 2006

2

Replies: 27

Views: 9K

Dec 5, 2006

[email protected]

C

L

Modify Claus code "Sub Array_Var_Column_Sort()"

L. Howard
Aug 22, 2014

2

Replies: 27

Views: 1K

Aug 27, 2014

GS

G

E

How to Parse a string; Delimiter is any Operator

EagleOne
May 1, 2007

2

Replies: 27

Views: 1K

May 17, 2007

[email protected]

E

S

Add Hours by Looping through Data Q

Seanie
Jun 22, 2011

2

Replies: 27

Views: 2K

Jun 24, 2011

GS

G

S

Constant in Formula

Sige
Sep 22, 2005

2

Replies: 27

Views: 857

Sep 28, 2005

Sige

S

G

Practical Macro Size Limit?

Guest
May 29, 2007

2

Replies: 26

Views: 995

May 31, 2007

Guest

G

M

Excel 2007 Menus - Ron De Bruin please

michael.beckinsale
Feb 6, 2007

2

Replies: 26

Views: 1K

Apr 20, 2007

Guest

G

H

Copy Range to new Range and keep DATE format??

HammerJoe
Jun 29, 2008

2

Replies: 26

Views: 1K

Jul 14, 2008

Dave Peterson

D

G

run time 1004: the method 'applycustomtype' for object '_chart' fa

Guest
Oct 12, 2007

2

Replies: 26

Views: 2K

Oct 17, 2007

Jon Peltier

J

R

anyone can help ?

ReD-DevIL
Mar 20, 2006

2

Replies: 26

Views: 829

Mar 29, 2006

ReD-DevIL

R

S

Tiered Pricing Calculations

Siper1
Aug 11, 2008

2

Replies: 26

Views: 1K

Nov 9, 2008

Jerry Beaucaire

J

M

Last used cell in column

mp
Feb 4, 2011

2

Replies: 26

Views: 1K

Feb 6, 2011

GS

G

G

Return to cell after sort

Geoff
Sep 11, 2004

2

Replies: 26

Views: 4K

Sep 14, 2004

Tom Ogilvy

T

A

How to find the most common pair and triplet numbers?

alessio971
Aug 11, 2007

2

Replies: 26

Views: 7K

Nov 30, 2018

ubatu05

U

E

Call VBScript from VBA, pass variable, return result to macro?

Ed
Jun 29, 2006

2

Replies: 26

Views: 10K

Jul 11, 2006

Karl E. Peterson

K

K

Subscript out of range

KJ MAN
Sep 14, 2008

2

Replies: 26

Views: 1K

Sep 17, 2008

Rick Rothstein

R

H

Process dumped into an array...and then back to sheet

Howard
Mar 26, 2013

2

Replies: 26

Views: 1K

Mar 28, 2013

GS

G

C

Cimjet
Jun 22, 2011

2

Replies: 26

Views: 1K

Jun 25, 2011

isabelle

I

N

Quick Date Entry European

Norman Harker
Apr 8, 2004

2

Replies: 26

Views: 1K

Apr 9, 2004

Norman Harker

N

G

Macro that can switch between tabs

Guest
Jun 4, 2007

2

Replies: 26

Views: 757

Jul 17, 2008

Don Guillett

D

C

Macro creation via VBA

crarbo1
Jul 19, 2009

2

Replies: 26

Views: 1K

Jul 28, 2009

crarbo1

C

G

Guest
Dec 3, 2004

2

Replies: 26

Views: 923

Dec 6, 2004

Alan Beban

A

D

how to call subprocedure from within procedure?

dreamz
Oct 31, 2005

2

Replies: 26

Views: 935

Nov 1, 2005

dreamz

D

H

Code to insert a coma

Howard
Jan 13, 2013

2

Replies: 26

Views: 1K

Jan 14, 2013

GS

G

G

Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools

Guest
Nov 12, 2003

2

Replies: 26

Views: 3K

Nov 17, 2003

Dave Hawley

D

L

Help with worksheet_change script

lousypianist
Jun 14, 2011

2

Replies: 26

Views: 1K

Jun 23, 2011

programmernovice

P

G

Is there a formula that can pattern match?

Guest
Nov 15, 2004

2

Replies: 26

Views: 6K

Nov 18, 2004

Dave Peterson

D

G

VBA - Click mouse to change cursor to cross hair that spans the en

Guest
May 23, 2006

2

Replies: 26

Views: 3K

May 26, 2006

NickHK

N

H

Loop returns only one value, does not loop & an assignment to columnhow-to problem.

Howard
Apr 2, 2013

2

Replies: 26

Views: 1K

Apr 4, 2013

GS

G

G

lock a range question

Gary Keramidas
Sep 30, 2005

2

Replies: 26

Views: 694

Dec 20, 2005

Guest

G

G

Complicated VBA Conditional Formatting

Guest
Jun 29, 2005

2

Replies: 26

Views: 1K

Jun 30, 2005

Guest

G

S

Graph Source Data

Saxman
Feb 6, 2007

2

Replies: 26

Views: 942

Feb 11, 2007

Jon Peltier

J

R

Lowest repeatable number in a range

Riddler
Oct 23, 2006

2

Replies: 26

Views: 4K

Oct 24, 2006

Riddler

R

C

Input Box selection and file open

cottage6
Mar 26, 2008

2

Replies: 25

Views: 806

Apr 2, 2008

Rick Rothstein \(MVP - VB\)

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: 898

Jul 27, 2006

TomBP

T

G

delete all blank rows in a spreadsheet

Guest
May 26, 2006

2

Replies: 25

Views: 982

May 27, 2006

Nigel

N

P

Please help with my code

Please Help
Dec 12, 2007

2

Replies: 25

Views: 832

Dec 20, 2007

Please Help

P