Macro to Combine 2 columns to make one column without merging
I found this macro courtesy of Dave:
Dim myRng As Range
Dim myArea As Range
Dim myRow As Range
Dim myCell As Range
Dim myStr As String
Set myRng = Selection
Application.DisplayAlerts = False
For Each myArea In myRng.Areas
If myArea.Columns.Count > 1 Then
For Each myRow In myArea.Rows
myStr = ""
For Each myCell In myRow.Cells
myStr = myStr & " " & myCell.Text
myRow.Merge acros...Chart Location
How to specify the location of a chart in a sheet (The
sheet contains 4 charts).The chart location should vary
dynamically depending on the values associated with it.
Thanks and Regards,
You need to specify the coordinates and dimensions of the chart's parent
chart object, in pixels.
With ActiveChart.Parent '' or With ActiveSheet.ChartObjects(1)
.Top = 50
.Left = 50
.Height = 175
.Width = 225
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTe...Expanding a distrobution List in a new mail
I have Outlook 2003 and some of my users who try and send a mail to a DL
are unable to expand the list because there is not a '+' sign next to
it. I can do this on my client. where is the setting for this? I have
been unable to find it. The real reason we are trying to do this is
because we need to print these lists some times.
Thanks in advance.
There is no such setting. All DL's in Outlook 2003 have this option by
Corrupt ones will not, and most DL's are corrupt by the time you get around
to using them--especially if they were created in an earli...new e-mail
???????????,??????? ???? ? ? ?: ????@???? ????: firstname.lastname@example.org ????:
????@???? ????????????? | ????
...DPM 2010 RC co-locate SQL Server
I'm creating a protection group for SQL Server 2005 SP3 (CU8) with DPM 2010
RC. I have about 15-20 small databases and about 10-15 larger databases.
When I create the protection group the option to co-locate is checked (and
not gray), but when the protection group is created I end up with many 10gb
disk partitions. Isn't co-location supposed to prevent that?
I read that the default for co-location is 30 databases (how do I increase
that?) so I tried hand picking the larger databases from the list rather than
the auto option and only using those in my protection group....Pivot Table - wont refresh
I've not experienced this problem in Excel 2000, but after
upgrading to Excel 2003, there's an odd problem. Has
anyone experience something similar - User error or bug?
1. Create pivot table with pivot table 'pages'.
2. The page selection list includes a listing that is not
in the raw data. Refreshing the pivot table wont reset. It
is possible to ascertain from the list order, which data
item is being incorrectly shown.
3. In the raw data, replace the name of the incorrectly
displayed data item with something else (eg 'ABC')
4. refresh the pivot tab...Incorrect date in line chart in Excel.
I'm having difficulty with a line chart. I've got two ranges of numbers of
two types of calls (from 1972 through 2004) that goes up from 50 to 7700. My
chart's Y axis has automatically decided to show from 0 to 16,000. On the
chart itself, my data placement starts at about 6,000 (for both 24 “F” calls
and 649 “M” calls in the year 1972) and goes up to a point above 14,000 (for
a figure that should only be just above 7000). I've tried to change the
scale of my Y axis, but when I am able to so (2 out of 5 times) my data then
goes off the chart. So I've looked at m...Excel opens with an error report whenever I Boot Up my computer
A couple of days ago, I noticed that whenever I boot up my computer, an error
report comes up indicating that Excel needs to close because of error. I
unistalled office and the message wnet away. But when I reinstalled Office,
the message came right back. Thoughts?
...adding a new record to a table from a form (works in edit mode)
I have a form which shows select field from a table (showing all rows of
data), and have 2 buttons , one to edit, one to add.
The edit button works perfectly
DoCmd.OpenForm "frm_TRA_EditRoute", , , "[anRouteID]=" & Me.Text62.Value,
acFormEdit, , True
the add button does not.
DoCmd.OpenForm "frm_TRA_EditRoute", , , , acFormAdd
in edit mode, the form loads up with all of the details (the autonumber
correct, the combo boxes drawing in the correct data), however in add mode
the autonumber box is just blank (doesn't say "(Autonumber)" like it ...QuickBooks export to Excel
Suddenly, my QuickBooks program no longer allows me to export to Excel.
Worked fine a week ago. I can log onto QB from every other pc in the office,
and export to Excel works. Any ideas?
Since you are exporting from QB I would start at that end.
What trouble-shooting have you done?
What message do you get when you try an export from QB?
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 06:41:02 -0700, SecurityGuy
>Suddenly, my QuickBooks program no longer allows me to export to Excel.
>Worked fine a week ago. I...Spreadsheet Protection & Sort
Is there a way to protect a spreadsheet (just one column of cells) yet
allow for the spreadsheet to be sorted?
Thanks for your help in advance.
If you want to sort only the unlocked cells of a protected sheet, you can do
so with XL2002. In Tools - Protection, you have to option of allowing sort.
Not available in XL97, don't know about 2000.
In 97, it's generally done with a macro that unprotects the sheet, does the
sort, then protects the sheet.
mvpearl omitthisword at verizon period net
"John"...Seeking new Bank Recommendation
I am currently a BankOne customer, but am dropping them due to the new ATM
service fee. BankOne now charges $1.50 per non-BankOne ATM transaction -
this is in addition to what the local bank that runs the ATM charges. I
travel A LOT and am always needing cash from a non-BankOne ATM.
Unfortunately, BankOne is also the dominant bank in my area - ATMs in
Walgreens, Dominicks, lots of branches. I am going to stand on principle and
cancel my accounts w/ BankOne however.
I was a Preferred Checking customer w/ BankOne for 10 years (no fees for
anythign if you kept a $2500 minimum balance - maybe it ...Using User input in excel VBA
I'm supposed to make an invoice of 4 items. Each item needs to have
user input for the description, price, and quantity ordered. Then I
need to calculate the cost of the 4 items. Then calculate the sales tax
at 6%. Then calculate the total cost including sales tax. This needs
to be done using VBA code in excel.
--I'm curious as to how to prompt the user to give me information.
--I'm curious as to how I would use the users input in another cell
once they entered it.
-- I'm curious also as to how VB will know that something is entered
once the user enters something into t...Location Location Location? No, Traffic Traffic Traffic! #9
Do you want a great backend product that is selling like crazy this week?
My readers are running to get this NEW CONCEPT!
I�m selling more this week than I ever did in the past months with any other program.
My commissions are climbing very fast. I�m really excited!
This is the best ad copy I�ve read in months! It sells.
If you haven't felt the shockwave yet, stop everything you are doing and read this to be one of the first promoters.
The inner circles of the shockwave are raking in the profits like fury.
This will pay us for years to come as it is the first �Wave� of the NEW I...New computer & moving an upgraded Trial version
i upgraded a Trial version of Money 06 deluxe online; but recently upgraded
my computer. i would like to move my .mny files over to the new computer but
cannot figure out how to reinstall money 06... since i originally downloaded
and then upgraded online i do not have any resource CDs. any suggestions?!?
Read more posts for how to reinstall the online-purchased licensed
application. This kind of thing happens all too frequently. Move the .MNY
files the same way you move any other data file.
"chris" <email@example.com> wrote in message
news:A9E8AF0...New Mail & Folder Expansion
This is a multi-part message in MIME format.
I have several rules which send new mail messages to sub-folders that =
I've created in Outlook. Typically I keep many of these folder trees =
collapsed. I'm searching for an Outlook setting or registry edit that =
will automatically expand the folder tree to show any folders that =
receive a new message. Any suggestions would be appreciated.
Colin M. McGroarty, MCSE, MCP...How to set default page for new tag window?
I am using XP with SP3 and IE8.
Whenever I click a new tag for IE8, I would like to set the default google
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
"Eric" <Eric@discussions.microsoft.com> wrote in message
>I am using XP with SP3 and IE8.
> Whenever I click a new tag for IE8, I would like to set the default google
> Does anyone have any suggestions on how to do it?
> Thanks in advance for any suggestions
Tools||Internet O...Excel Data Sources
I have created a standard line chart, which I hoped to represent two
different data sets on (x-axis = time, y-axis = %).
Data Series 1 plots perfectly.
Data Series 2, instead of plotting the second data series, plots Data Series
1 + Data Series 2 (added together). When you add data labelling, it states
the % as the correct value, i.e. it says 7.26% but plots the point 5% (-2.26%
Rather confused, I cannot determine what I am doing wrong. I'd suggest a
fundamental error with excel, but that seems ridiculous. Please help!
I suggest that you go back and look caref...Excel opens 2 copies of the file...
Hi, i did a search with no results, although im sure its been aske
when i open a file (one we use every month) it all of a sudden decide
to start opening 2 copies of it. I couldnt find a setting where i
tells it to do this... im sure its a easy fix. Anyone know?
Thanks in advance
johnnyrad's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=573
View this thread: http://www.excelforum.com/showthread.php?threadid=27288
http://www.contextures.com/xlfaqApp.htm...Import Vendor Bank Info for EFT
I need to know if there is any way possible of importing to GP10 vendor bank
account information for EFT Payables.
We had to merge one of our GP databases into another shortly after we
upgraded to GP10, we have over 200 vendors on the EFT payables program and
would like to import the bank info to the EFT tabs instead of hand entering
I checked the IM.mdb sample imports and it doesn't look like the new eft
bank fields were added to the available fields for import on the vendor
I would appreciate anyone's assistance/comments on this.
BTW - we had to consol...New entity to assign to queue...
How can I assign new custom entity to queue?
Afraid you can't. Only Activities & Cases can be routed to a queue.
MVP - Microsoft CRM
"Cyrus" <Cyrus@discussions.microsoft.com> wrote in message
How can I assign new custom entity to queue?
But is there a way to create new custom Activity entity?
"Matt Parks" wrote:
> Afraid you can't. Only Activities & Cases can be routed to a queue.
> Matt Parks
> MVP - Microsoft CRM
No. be...How do I sort data in excel by color?
Sorry, English isn’t my mother tongue, hope you’ll be able to understand my
I have a sheet with four columns of data. Three of them contain numbers and
the last one contains a word like the example bellow.
In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew
Now, if I want to quickly find all rows containing the word “Andrew” I go to
Edit, click Find and click replace and type Andrew into the “Find what” space
and Andrew into the “replace with” space. After that I format the fon...upgrading from one IMac to another
how do I transfer msft office for mac from old IMac to new IMac
Probably the easiest way is to connect a firewire cable between the two
macs. Start one of them normally. Start the other one up holding while
holding down the T key. The hard drive of the one you hold the T key down
will mount as a volume on the one that is started normally. Then you can
simply drag and drop the files as you need to.
All responses should be made to this newsgroup within the same thread.
About Microsoft MVPs:
Search for help with the free Google search Excel ...Macro location
I have a file called PERSONAL.XLS that contains all my macros.It is located
I had reason to copy that file and an other Excel file to drive A(Floppy)
Now every time I try to run a macro the computer looks to drive A.
How can I stop this ?
Norton Virus checker 2003 says this email is clean
First off, you should never copy files from Excel to a floppy - it
gives too many problems because of the way Excel uses its temporary
file. The file can get corrupted. Save to our hard drive and copy from
The change of location is "a feature not a bug" <grin>...date in excel #2
I'm trying to solve a problem...
If I put "x" in A1 I would like for excel to set date
and time in A2 when I put "x", B1 -> B2, ...., and so on.
NOW() does not work because every time I close and open excel it
Is there a formula to set cell date and time without excel refreshing it on
without using "manual calculations", and possible without macros and VBA?
In article <firstname.lastname@example.org>, MySelf.2001 at REMOVEmyself.2001
> I'm trying to solve a problem......