|
Don - Please help on another subject - headers
On this same directory workbook. I have a header that I want on all pages.
I made changes to the ALL ws and then I recorded a macro that would take the
text from ALL ws and copy to LAST_TITLE ws. It worked when I was recording
the macro, but when I run the macro - all I get is the screen jumping and
nothing changes. I need to do the same on the ALL footer. I am trying to
make this '...
|
2 |
12/16/2008 8:41:24 PM |
|
|
Range to be copied changes
I am working with a phone directory listing. On the ALL sheet is where I
list all listings. I will be adding and deleting listings as time goes on.
I then want to copy from ALL into another worksheet (Last_Title) where I
paste, then I will delete a column and then I need to format the listings to
have gray background every other row. But the range changes. Example I will
add a new li...
|
6 |
12/16/2008 8:26:17 PM |
|
|
Excel 2003 VBProject Missing reference
Within Excel 2003 this macro:
Private Sub Workbook_Open()
Dim wkBook As Workbook
Dim refCurr As Object
Dim i As Integer
Set wkBook = ThisWorkbook
'Deselects 'Missing'(IsBroken) references from the VBProject References
dropdown list.
For i = wkBook.VBProject.References.Count To 1 Step -1
...
|
5 |
12/16/2008 8:01:03 PM |
|
|
Export only current sheet to email?
Hi,
I'd like a way that I can place a form button on a worksheet in Excel, that
when pressed, just exports the current sheet to a new Excel file, (preferably
with a message prompt to give it a file name - .xls added automatically),
saves it to the desktop, and then automatically attaches it to a new email in
Outlook. (Similar to Send to mail recipient as attachment, except only with
t...
|
6 |
12/16/2008 7:41:01 PM |
|
|
Create sheet with records for each rep in filtered list
I have obtained a macro (AdvFilterRepFitered) that can create sheets with
records for each rep in filtered list (if a sheet already exists for a rep,
it will be cleared, and the data will be extracted to that sheet). It will
create sheets with rep's name.
How could modify it so the names for the created sheets will be C1, C2, C3,
C4 (not rep's name)...(depending on how many reps we h...
|
4 |
12/16/2008 7:29:47 PM |
|
|
Why doesn't the Control tab appear in the Format Control window?
I'm trying to tie a scroll bar to a cell in Design mode. The tutorials say
to right click on the scroll bar and choose Format Controls. In Format
Controls, I am supposed to use the Control tab. My Format Controls window
does not have a Control tab!...
|
2 |
12/16/2008 7:01:00 PM |
|
|
Formatting Several Sheets
I have one sheet that serves as an menu to name several new sheets in
my workbook. I would like to add to this code. I need Range("a3") on
each NEW worksheet to contain a heading from the same list. It would
say, "Regional Office 325 2008". The "325" for the header would come
from the sheet.name. Any ideas?
Sub copyCleanTemp()
Dim rngName As Range
Dim i As Integer
Set rngN...
|
2 |
12/16/2008 6:59:37 PM |
|
|
ARRG! Names not showing up, can't use in validation or ListBox??!
In XL 2007, I'm naming ranges using
nm = wks.Name
a = a - 1
rg = wks2.Range(Cells(21, b), Cells(a, b))
wks2.Names.Add _
Name:=nm, _
RefersTo:=rg, _
Visible:=True
I can see them in the Name Manager, but I can not see them in the
Names box (upper left), nor can I reference them as a Data Validation
source or a ListBox source.
What I real...
|
5 |
12/16/2008 6:51:27 PM |
|
|
formula for text
I am using Excel for course scheduling. I have a drop-down menu in one
column with departments. If the user selects a given department, I would
like the next column then to have a drop down menu showing them the names of
courses available in their department only (rather than one huge list of all
the course names from all departments). I do not know whether Excel has a
formula that m...
|
3 |
12/16/2008 6:51:02 PM |
|
|
Creating macro to capture details from Lotus
Hi,
I have an excel file and I want to create a macro in it.
This macro should capture details from lotus notes DB and should copy all
the required details in the file for future reference.
Can't figure out a way to to do. Is it possible to create a macro or without
a macro?
Thanks and Regards,
abadd0n...
|
2 |
12/16/2008 5:41:28 PM |
|
|
Procedure works from VBA but not the Ribbon
I get this "Incorrect Function" error and I have narrowed the problem down to
it being only 2 lines of VBA code.
Sub xyz()
ActiveWorkbook.Save
End
End Sub
I need the "End" line of code to clear all variables (there are hundreds of
them). When I run this straight from VBA there are no problems but when I run
the procedure from a ribbon button the "Incorrect Function" error pops...
|
3 |
12/16/2008 5:38:41 PM |
|
|
Open Crystal Reports from Excel?
Hi All.......
Is it possible to open Crystal Reports from within Excel by macro control
and extract a previously created report back to Excel?
TIA for any suggestions
Vaya con Dios,
Chuck, CABGx3...
|
1 |
12/16/2008 5:24:00 PM |
|
|
Getting the count from autofilter
I recorded a macro to use autofilter. I do not know how to access the count
of the result after filtering on a column. Let's say I have 10 rows and after
I filter only 2 rows show up. I want to access the result that gives me 2. I
think this is count but wha tis the code to get it.
Thanks
--
Jason V...
|
3 |
12/16/2008 4:49:01 PM |
|
|
Changing Cell Contents
I have an employee list with names (First Last) in one column. Is there a way
to get the last name to show up first and then the first name? TIA.
--
I am running on Office 2003, unless otherwise stated....
|
4 |
12/16/2008 4:16:11 PM |
|
|
Urgent
Hi!
Could an expert spot what is wrong with this chunk?
For f = 1 To 39
If Not Workbooks("BCS Summary Lines.xls").Worksheets(1).Cells(f + 9, 105) =
Workbooks("BCS Summary Lines.xls").Worksheets(1).Cells(f + 10, 105) Then
Range("d10:cz477").ClearContents
Range(Cells(f + 9, 4), Cells(f + 9, 4).Offset(11, 100)).Value =
Range(Cells(f + 1009, 4), Cells(f + 1009, 4).Offset(11, 100)).Value
...
|
5 |
12/16/2008 4:09:55 PM |
|
|
Comparing Text Contents of Cells
Please tell me how to compare the contents of cells that contain text. If I
try to compare a cell that contains two identical strings, they never equal
each other. For example, if I try a statement similiar to the following:
If Cells(1,1) = Cells(2,1) Then
msgbox "They are equal"
End If
I have never been able to get this to result in a true condition meaning
They are equal is ne...
|
5 |
12/16/2008 3:50:20 PM |
|
|
Codes for Undoing
Hi
Could somebody give me codes for undoing? It is urgent.
Sub Test ()
Cells(1,1).ClearContents
Application.Undo
End Sub
The above does not work.
Thanks....
|
5 |
12/16/2008 3:25:01 PM |
|
|
Data segregation..
Hi,
I've a Spread sheet where a word comes in different part of a sentence. Is
there any way to list the find how many times the word is repeated.
Regards,
Praveen.....
|
4 |
12/16/2008 3:23:10 PM |
|
|
Open the SaveAs Dialogbox
I am trying to open the SaveAs dialogbox when the user clicks on a
commandbutton. Has anybody managed to do this any help would be much
appreciated.
Regards
Charles...
|
3 |
12/16/2008 3:18:18 PM |
|
|
Cann't Copy codes from module
Suddenly, today morning, I notice that I can copy codes from the modules.
Atleast twenty spreadsheets are there which needs to be daily updated and
manipulated. What might have gone wrong in excel. Why the copying
function,ctrl C nor copy from Edit works. Very urgent request ,this one is.
Please help.
--
beetal...
|
3 |
12/16/2008 3:14:01 PM |
|
|
Need help with Names, please - must finish today!
Using Excel 2007. In a Workbook_Open sub, I set some named ranges
using
wks2.Names.Add _
Name:=nm, _
RefersToR1C1:=rg
I am trying to clear the contents of these ranges and delete the names
on Workbook_BeforeClose using
For Each nm In Me.Names
wks2.Range(nm).ClearContents
wks2.Range(nm).Delete
Me.Names(nm).Delete
Next nm
It's not working!...
|
7 |
12/16/2008 3:11:32 PM |
|
|
search a row for data then move to next row
Hi,
Iwant to search 10 columns of data one row at a time (50 rows). If
the row contains the value "SL" then I want to add the value of the
first column of the current row to a variable. I've tried looping
through the entire range, but I then end up with duplicated data. I
need to move to the next row once the first instance of "SL" is found.
I have this so far (but it does not work
...
|
5 |
12/16/2008 2:16:24 PM |
|
|
Insert function dialog closes when I click a picture in Excel 2007
Hi All,
I have developed an Addin in .NET that displays some information on
the worksheet by reading a file. A number of pictures are generated
and put on the worksheet while reading the file.
The problem is :-
I open the Insert Function Dialog to insert a User Defined Function
into the worksheet
I choose a function and then a new dialog is displayed to get the
target cell
Now if I se...
|
1 |
12/16/2008 1:03:36 PM |
|
|
Further Help/Advice Required
In several previous posts, many of you will be aware that I have
managed to devolve most (>95%) of the VBA code belonging to a large
Excel application from the workbook into a DLL, which I produced using
VB6 from Visual Studio 6.
The success of this enterprise has been furthered by help obtained in
this forum. The resultant workbook/DLL does not interfere with any
other Excel workbook t...
|
2 |
12/16/2008 11:41:41 AM |
|
|
comparison of 2 approaches for identifying file existence
hi all,
I have come across the below techniques for identifying if a file/folder
exists, both seem to work but is one technique "better" than the other?
if not dir(strfullpath,vbdirectory) = vbnullstring then doesfilefolderexist
= true
'or
if len(dir(sbasefolder, vbdirectory)) > 0 then doesfilefolderexist = true
TIA
Rob
__________________
Rob Brockett
NZ
Always learning & t...
|
7 |
12/16/2008 10:52:01 AM |