How do you change the column names,in Excel?
I am making a chart and I need to change the column names in Excel. I use to
know how, but seem to have fogotten. Does anyone know how??
Thank you, Angel :0)
If you mean the grey buttons (A, B, C...) at the top of the worksheet,
they can be changed to numbers (1, 2, 3...), but you can't create your
own column headings.
Instead, you can add your headings to the first row in the worksheet.
Then, select row 2, and choose Window>Freeze Panes
The heading row will stay locked in place as you scroll down the worksheet.
> I am making a chart and I need to change the ...HOW: Click Formula Hyperlink To Trigger Macro
I have a column (Column 6) where every row contains an IF() formula
that results in a HYPERLINK() formula if the previous cells in that
row each contain data. In other words, a hyperlink shows up if the
row is filled out. If the hyperlink shows up, and the user clicks it,
I want a macro to be triggered. I want to trigger a macro that draws
upon the data from the other cells in that row.
My first discovery was the Worksheet_FollowHyperlink event. It seemed
perfect. It triggers when a Hyperlink Object is click and captures
that location of the cell where the hyperlink was clicked....Name>Define shows in sheet
How do I get rid of the name defined for a range and which shows in the
sheet? It does not print but it cloggs the view of what is underneath.
These don't show up unless your zoom is below 40%. That's pretty small,
isn't it? I don't think you can turn these labels off.
Jon Peltier, Microsoft Excel MVP
> How do I get rid of the name defined for a range and which shows in the
> sheet? It does not print but it cloggs the view of what is underneath.
&...Formview update fields
I have a formview that uses an ObjectDataSource. If I place a field on
the formview that is not part of the update statement I get an error.
I thought that the fields that are included in the update statement
are those declared in the update parameters collection. If I have the
EXACT same fields on a gridview the update is successful.
Also is there any way of tracing the database execution so I can view
all the statements going to the database?
...Macro Help needed #2
I'm trying to record a macro but I'm having difficulty with a particular
I'm trying to copy text from a particular cell, Lets say Cell A1, and then
go to the "Sheet Tabs", currently labeled Sheet 1, and paste the text to
rename the sheet.
Can Someone tell me what I'm missing from the following macro to make this
' Macro Macro
' Macro recorded 8/18/2005 by Anthony Amato
Sheets("Sheet 1").Name = " &qu...macros run twice
Hi - I have been working on some Macros. I am compiling a macro that runs
other macros. I have two noticeable problems.
1 - My SaveAs macro runs fine by itself. But when called or ran by another
macro, (which calls more than one macro) the SaveAs macro it stops.
2- Many of my macros, when ran by another macro (which runs more than one
macro) cycles through twice.
My specific question is about no. 2 and the following are the individual
macros and the macro that runs them.
'''''This macro copies values from sheets 1, 2, 3, 4...Link row to Column
I have a spreadsheet that has multiple tabs. I want to have a row of data be
linked to a column on the other tab. For example:
A1 linked to A1
B1 linked to A2
C1 linked to A3
D1 linked to A4
Is there an easy way to transpose the link so that I don't have to manually
create the link for each one? I have about 70 or so and growing.
Cell A1: =INDIRECT("Sheet2!A" & COLUMN(A1))
and drag across the columns
"Aaronous" <Aaronous@discussions.microsoft.com> wrote in message
news:8EA38615-6B24-402B-8C2A-78E4189A4C45@microsoft.co...macro with wildcards
Operating System: Mac OS X 10.4 (Tiger)
I'm trying to create a macro that will fatnd all characters,words, lines or paragraphs the are grouped between two brackets. I've tried [*], but get no results.
In article <59bb65ef.-1@webcrossing.JaKIaxP2ac0>,
>Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel
>I'm trying to
>create a macro that will fatnd all characters,words, lines or paragraphs
>the are grouped between two brackets. I've tried [*], but get no resu...Outlook Sales not working after upgrade
I had the Adventure Works test set up and working with
version 1.0. Then after I upgraded the web interface
works but the Outlook Sales client doesn't. It acts like
it installs correctly and when you open Outlook it has
the CRM folder, but there is nothing in it. Any ideas?
...Delete Macros Macro
I have some xl files that have many macros in them. For
example 20 xl files with 10 macros in each file.
I have the following macro in it's own xl file that I use
to delete the macros in the other files before I save the
xl files in another directory.
Dim vStop As Double
vStop = 0
Do Until vStop = 50
Application.SendKeys Keys:="%tmm", Wait:=False
Application.SendKeys Keys:="%D", Wait:=False
Application.SendKeys Keys:="Y", Wait:=False
vStop = vStop + 1
This works fine exce...Macro's
If I delete/remove a macro after the formula's have used the macro to
tabulate calculations, the next time a go into the file will the amounts
still be there? Or does the macro need to be in place at all times?
If it's a macro that places values (or builtin formulas) into cells, then you
don't need the macros.
But if it's a UserDefinedFunction macro (and there are cells that use that
formula), then you'd need that code. (Or convert those formulas to values.)
And when you're cleaning up the macros...
Debra Dalgleish has some instructions:
http://www.contexture...Online updates don't work. Money needs exchange rate
I have MS money 2005 and my online updates have been working great for about
a year now. Recently online updates stopped working. I get no error I only
get a message that says "Money needs an exchange rate for currency is one or
more accounts." The only thing is I have not changed anything and all my
accounts are in US dollars. I can run just the Quotes and exchange rates
update and that works but my other accounts will still not update because
they keep saying the need an exchange rate. Has anyone seen this or know how
to fix it?
In microsoft.public.money, Todd wrote:
>...Transfer Macro in Excel
I am trying to transfer informtion in one sheet to another sheet in the
same workbook. I have a macro to process this information from the
first sheet to the second. I keep getting an error in this Process
macro at the line.
The first sheet is called ProblemSheet and the second sheet is called
Processed. The line above is taken from the process macro on the
ProblemSheet page. Do I have to name a certain cell as "END" on either
sheet? Any help with this would be really appreciated.
Message posted from http://www.ExcelForum.com...windows mail not work with office 2007
I have office 2007. Recently upgraded to Windows 7. Have Windows mail, not
Outlook. Cannot email from office 2007. The email prompt is faded out and
cannot be accessed. How to activate it?
What do you mean, you can't email from Office 2007? Just how are you =
Windows Mail is not designed to run in Windows 7, and although there are =
hacks to make it somewhat functional, it is not so easy=20
to get it to be recognized by Windows 7 as capable of assuming the =
default mail program role. The best solution is to install=20
Windows Live Mail.
How do I get a mcro to run at a certain time during the day?
Take a look at Chip Pearson's notes:
> How do I get a mcro to run at a certain time during the day?
See replies to your other similar post in Excel.Misc news group.
Gord Dibben MS Excel MVP
On Thu, 20 Aug 2009 13:08:01 -0700, Davo1 <Davo1@discussions.microsoft.com>
>How do I get a mcro to run at a certain time during the day?
...Pivot Table data output on multiple sheets
I would like to know if there is a way to automatically get Excel to
create the same pivot table on several sheets with each sheet showing
a selection of the data.
On one sheet the pivot table which relates to the male
Another sheet the pivot table relating to the females
AFAIK this is not possible
"Sean" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I would like to know if there is a way to automatically get Excel to
> create the same pivot table on ...Puttin Money 2004 on another PC
I've got a brand new Dell Dimension 3000 running XP Pro / SP2 and loaded
Money 2k4. Originally, I tried accessing my .mny file on my white box running
2k Pro from the Dell. The name at the top of the window changed reflecting
the .mny file name but no data appeared inside the Money 2k4 window.
- I uninstalled Money 2k4 and re-installed it on the Dell and applied all
the MS updates for Money. Still no luck...
- I copied the file off the 2k Pro box and onto the Dell. Still no luck...
- I executed a repair on the file and tried accessing the new one. Still no
- I restored the ba...DataGridViewComboBoxColumn change to automatically update DataGridView
I have a standard DataGridView. One of the columns is a
DataGridViewComboBoxColumn. When I select one of the ComboBox items, I want
to trap the change and add additional columns based on the item selected in
the ComboBox. I've tried using CellValueChanged for the DataGridView column,
and a bunch of other events, but none of them is fired when the
DataGridViewComboBox value is changed. What event can I trap to make this
happen? Right now as I said, I am using CellValueChanged, but of course the
event doesn't fire until I click on another cell...
Message posted via DotNetM...workbook macro help
Hello there, I would like some help with a macro that I need to run in
a workbook. this is the macro.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
what or how do I get it to work for every worksheet in the workbook, I
currently place the macro in each worksheet which is very time
consuming. Is there a way to place the macro in the workbook so all
worksheets have the autofit macro? and can I single out a worksheet so
as not to have the macro.
Probably better to use the Change event than the Sel...How do I change macro text with another macro?
I have a set of workbooks that all have a similar macro in them. Each of
these macros contains a string I need to change, but to change it manually
in each file is time prohibitive - 60+ files.
Given I already have one of these files open with a seperate macro, from the
seperate macro, how do I access the module - say Module1, search for the
line that contains the text needing to be changed, change it and then close
I already have the list of files and the loop to go through all of them. I
am just unclear on how to change the Module1/Macro text from another macro.
Any ide...Paste feature does not work; copied or cut are not in Clipboard.
While working in just one document I want to move a section from one area of
the document to another. I have used cut and paste or copy and paste all of
the time in many other documnents. However, it appears that in this document
I can cut or copy but the items are not found in the Clipboard. Then when I
go to paste the selected item the paste feature is grayed out so that I can't
paste it to the new location in the document.
I have gone to tools and options to fix but can't find a feature to do so.
Can anyone instruct me what is happening and how I correct this?
...Relocating a macro
I accidentally created a macro in the worksheet I was working on at the
time instead of in PERSONAL.XLS. I have tried to move or delete macros
before and gotten annoying messages afterward when I opened the
original file saying "VBA Error!" etc, etc. In some cases, XL couldn't
find the macro after I moved it. What is the correct protocol for
moving a macro from a regular spreadsheet to the PERSONAL.XLS
spreadsheet without causing complications?
Perhaps you could indicate a bit better what you actually did.
If you are running a macro from Alt+F8, even though yo...find formula that will look up a value in a specific column and .
I am looking for a formula that will find a certain text value (open) in a
column (J) and pull that row (or row #) to a new sheet. Does anyone know if
there is a way to do that?
Providing the data starts in J1 the formula below will return the row
number. Bear in mind that a formula can only return a value, not move data.
You may also be looking for a VLOOKUP, it was just the way your question was
phrased that made me return a row number
Microsoft MVP - Excel
...Run multiple Macros or macros from within other macros ?
I would like to run multiple macros at startup. What code should be used in
the Private Sub Application_Startup command in the ThisOutlookSession area ?
If the names of my macros were below what would the code to look like ?
I have looked at the samples from previous posts and cannot determine how to
make them apply specifically to my needs.
In Excel you can use the Run "Macro1" line and it would run that macro. Run
does not work in Outlook I suppose because I kept getting an error.
Also - What code is needed to execute a macro from w...I have email type headers on the top of speed sheet How to remove.
I have email type headers at the top of my excel sheet
How do I remove this.
I can't find where it came from
It is not in the toolbars menu
could you post an example
> I have email type headers at the top of my excel sheet
> How do I remove this.
> I can't find where it came from
> It is not in the toolbars menu
Click on the Mail button in the standard toolbar
And save the file
Regards Ron de Bruin