|
|
Macro to Un Hide filtered rows by
JeffK
I have this Macro
Sub Macro2()
Const csPWORD As String = "123"
ActiveWorkbook.Worksheets("broker").Unprotect Password:=csPWORD
...
|
|
3 |
42 |
|
|
|
.PrintQuality = 600 by
Miskacee
I have a spreadsheet which runs fine whenever i run it. whenever someone
runs it, they get an error on : .PrintQuality = 600 and says unable to set
the...
|
November 25th 09 11:10 PM
by ker_01 
|
3 |
37 |
|
|
|
Formula throwing up an error by
ker_01
Look at where your double quotes are located; each set surrounds something
that Excel will treat as a single string. Also, you will need a "&" between
each...
|
November 25th 09 11:06 PM
by ker_01
|
0 |
32 |
|
|
|
Sumproduct gives #Value! when answer=0 by
DogLover
I have a SUMProduct formula that I wrote in VBA. It works fine until the
combination in the criteria is such where there are 0 records, rather than it...
|
|
7 |
36 |
|
|
Expand and Collapse rows using a macro by
JeffK
I have a Spreadsheet that as time goes on will grow quite large. In Column
A, the data entry person can choose from 4 options (In progress, Sold,
Cancelled,...
( 1 2)
|
|
16 |
234 |
|
|
|
|
November 25th 09 09:44 PM
by sam
|
13 |
93 |
|
|
|
Calendar Control 8.0 question by
Robert Crandal
Is it possible to restrict the date ranges of the Calendar
Control 8.0?? I only want the year 2009 to be selected
from the drop down box.
Thank you!
|
|
7 |
42 |
|
|
|
smart tags by
tpeter
I am working in Excel 2003 and have a workbook with multiple tabs. The
information on tab "REC" needs to be copied into tab "REC" I have build the
macro to...
|
November 25th 09 08:59 PM
by tpeter
|
1 |
17 |
|
|
|
|
|
3 |
27 |
|
|
|
|
November 25th 09 08:44 PM
by tpeter
|
2 |
37 |
|
|
|
Start up file doesn't open by
jc
I have a file that is in my designated startup file that is suddenly not
opening after haveing opened fine on start up for a long time.
I am able to open the...
|
November 25th 09 08:42 PM
by jc
|
1 |
19 |
|
|
|
smart tags by
Dave Peterson
Did you really mean to write that the information on tab "REC" needs to be
copied to tab "REC"?
That doesn't make sense to me.
And since your macro works...
|
|
0 |
19 |
|
|
|
|
|
3 |
36 |
|
|
|
How to Sort Merged cells for worksheet? by
Dave Peterson
I think you're going to fail at this for the same reason it fails when you try
to do it manually.
Instead, I'd drop the merged cells completely and put the...
|
|
0 |
32 |
|
|
|
Open and Save Files in Directory by
Daniel Jones
I'd like to be able to select a directory and for each .xls file found
in the directory 1) open the .xls file 2) write the name and date
saved in another...
|
|
1 |
23 |
|
|
|
Capture data from cell before Enter by
jayklmno
Is there a way to capture what the user types into a cell before they hit
enter? I would then feed this data into a lookup to prompt the user with the...
|
November 25th 09 08:09 PM
by FSt1
|
1 |
25 |
|
|
|
Count occurrences of filename in column by
Lucky[_6_]
I want to use VBA to count the occurrences of a filename in column M,
such as "myfile.xls". Problem is, each time the name appears (after
the first one),...
|
|
5 |
33 |
|
|
|
I need help with VBA and a CSV file output by
DStrong
I am using Excel 2003 in XP Pro.
I am trying to export/saveas one tab from a workbook that contains one tab
and one column of data into a CSV file.
My data...
|
|
1 |
21 |
|
|
|
If(vlookup statement by
Nikki
I have three columns that I need to return a vlookup value.
A B C
8 2 PSS
I want to lookup column A in my table to return the name,...
|
November 25th 09 07:39 PM
by Nikki
|
0 |
23 |
|
|
|
Loop without Do by
Marc Gendron[_2_]
My problem is that I get a "Loop without Do" statement (my code might have
other problems....I'll get to them later !)
No need to tell ya guys I'm a...
|
|
2 |
27 |
