|
|
Hyperlinks by
mevetts
Hi,
I am trying to integrate some hyperlinks into my workbook, essentially
all they are doing is jumping from one area on a sheet to another area
on the same...
( 1 2 3)
|
|
25 |
300 |
|
|
Use Named Range instead? by
David
With a lot of help from folks here, I've got the following working:
Sub PrintMine()
Dim HPB As HPageBreak, FoundCell As Range
Dim iCtr As Long, NumPage As...
( 1 2 3)
|
|
25 |
275 |
|
|
|
|
25 |
443 |
|
|
How to allow "if then" text? by
Kenshe
Looking for a way to allow only three possible entries into a field and
using a one letter entry to spell out the full word of that entry,
Example:
If "P"...
( 1 2 3)
|
|
25 |
449 |
|
|
|
March 26th, 2009 03:14 PM
by Roger
|
24 |
378 |
|
|
pulling out Numbers by
peyman
hi,
how can I pull out numbers from a string?like:
aa012985 to 012985
12ab-059 to 12059
the letters or characters might be either at the first, middle or...
( 1 2 3)
|
|
24 |
265 |
|
|
email by rows by
DaleL
hello All:
I'm looking for a macro that will go down a sheet and look for the
email address and mail every thing in that row to *ONLY* that person no
matter...
( 1 2 3)
|
|
24 |
593 |
|
|
problem in VB codes by
peyman
hi,
I have a very simple code ,but I don't know why it doesn't work.
Private Sub CommandButton11_Click()
Range("G13:I32").Select
...
( 1 2 3)
|
October 23rd, 2007 04:38 PM
by peyman
|
24 |
193 |
|
|
A function to Turn Formula into Text? by
lawson
Hello, as an engineer, I often have to show a formula from a book in one
cell, show the formula with my values in it in the next cell, then show the...
( 1 2 3)
|
January 3rd, 2008 10:57 PM
by lawson
|
24 |
261 |
|
|
Counting non-numeric values by
paljowestsub
I have a spreadsheet with the letter x in various cells. I want to count the
number of x's in a particular row of cells. What formula do I use and how do
I...
( 1 2 3)
|
|
24 |
158 |
|
|
Changing a number into time by
James
In my sheets for work i have basic formulaes to work out a basic time such as
=SUM(F140/7+H140+J140-60)
Which is this the amount of packs per hour (f140)...
( 1 2 3)
|
January 13th, 2008 11:21 PM
by James
|
24 |
195 |
|
|
Lookup function/sum function by
Secret Squirrel
I have a worksheet (sales orders) that has a list of sales orders that I need
to total up on a different summary worksheet by month. On the sales order...
( 1 2 3)
|
November 21st, 2006 02:46 AM
by JMB
|
24 |
146 |
|
|
|
|
24 |
313 |
|
|
|
|
24 |
336 |
|
|
|
|
24 |
276 |
|
|
calculations quit working by
CJ
Our new network administrator tried to keep all company computers from going
on the internet, and in doing so he royally screwed up several spreadsheets
on my...
( 1 2 3)
|
November 17th, 2005 07:09 AM
by Doug T
|
24 |
309 |
|
|
|
|
24 |
941 |
|
|
|
July 19th, 2006 09:35 AM
by milos
|
24 |
427 |
|
|
|
|
24 |
381 |
|
|
|
|
24 |
234 |