VBA Worksheet Event Change or Selection Question, please assist me
Two fantastic people were kind enough to provide me these two codes
below, and now I'm trying to see if I can expand it to include other
columns and data in a worksheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myC As Range
If Intersect(Target, Range("P:P")) Is Nothing Then Exit Sub
Application.EnableEvents =3D False
For Each myC In Intersect(Target, Range("P:P"))
Range("Q" & myC.Row).Value =3D Date - Target.Value
Application.EnableEvents =3D True
Private Sub Worksheet_Change(ByVal Tar...Combine Bar with Single Line Chart
Please can someone help me with this question. I am trying to create
a bar chart with a single line chart.
The bars will display the totals for various years i.e.
The line chart will show how 2008 is performing on a weekly basis i.e.
01/01/2008 = 100
07/01/2008 = 101
14/01/2008 = 102
The bar chart for 2008 will reflect this also, updating each time a
new week is added.
The Y Axis I will assume display a total i.e. 99-111 for example.
The X Axis needs to show the dates plotted for the line chart
01/01/2008 - 31/12/2008 (weekly) but how...Routing Engine not starting, please help ASAP
Exchange and Windows 2003
I cannot get the Exchange Routing engine to start up. Upon startup I get an
event ID 7023 telling me that the path is not found. Everything else works
and starts up just fine, people can open mailboxes, but cannot send/receive
I read online that it sounds like the metabase.bin file is corrupted. I
uninstalled/reinstalled IIS, reinstalled Exchange 2003, and have reinstalled
Exchange 2003 SP1, everything works except that I still cannot get the
routing engine to kick back on.
Any suggestions! Thanks!
Was this an OEM preinstall? I recently bought a ser...Help Microsoft Office 2003
After now using Microsoft Office 2003 for about 3 months now, have suddenly
noticed that my email messages have just started showing strange symbols for
certain punctuation. This does not show as I type... but the recipent sees
these symbols when the message is received. I can see it when they reply
The strange symbols show for the apostrophe and sometimes for the
exclaimation. I do not recognize the symbols.
I do not have caps lock on, do have number lock on. None of the symbols show
on my keys.
it's caused by character encoding. What email client and....pst folder help
How do I put a .pst folder in My Documents for constant up to date copying?
Mine seems to be in a folder called Office Data File which I cannot open but
do not see any pst file...can someone kindly help me out here?
Right click the pst in outlook and select properties and then click Advanced
You will see the location of the file.
Depending on your view settings it may be hidden.
Close the pst, (right click it, close)
Move the file to the location you desire.
select File - Open - Outlook Data File
Browse to the file and select it. OK
&quo...illegal name? [noobie, please be gentle]
I am attempting to name a column as "fy2007"
xl refuses to accept this. Why?
Note that "fy2007" appears to satisfy all the naming
guidelines, as listed in the help file.
Also note, "fy_2007" is acceptable.
FY2007 looks like a cell in column FY in row 2007.
You could name it
Or most anything that doesn't look like an address.
> re: xl2k
> I am attempting to name a column as "fy2007"
> xl refuses to accept this. Why?
> Note that "fy2007"...Help with macro to choose printer
I am new to macros in Excel and this is what I did to print a worksheet:
ActiveSheet.PageSetup.PrintArea = "$A$1:$W$35"
Selection.PrintOut From:=1, To:=1, Copies:=1, Collate:=True
Works great except that I want to select the printer to use and the macro
won't stop at the point to choose printer.
Any way to work around this?
Any help is greatly appreciated.
Emilio,this wil...Help with an expression to calculate a profit from one of three fi
Using Access 2003 SP3 - in Forms
I know I'm probably asking a very complex question, so a very big THANK YOU
to whomever can help.
I am doing a detailed inventory and need help with an expression in my form
that will calculate my profit based on one of three fields. Only one field
would have the end data.
To clarify what I am working with: Most stock items come by the "unit" and
contain multiple "subunits" which, in turn, contain smaller "pieces."
However, some "units" only come with "subunits" and some only come as &quo...Excel Tool Bars
Lately, when I open Excel, the top Excel name bar and the bottom tool bar are
not on the screen. It appears that the worksheet is too large to be contained
on the screen.
Can't tell from your description, so just trying to grasp at straws..
-- are the toolbars floating, if so drag to correct position so the become docked
Applies to toolbars but not the name box and address bar.
-- do you have problems in other applications, i.e. Display settings, screen resolutions
-- is the zoom control at 100%
-- What happens in Full Screen mode and in restore (buttons upper right...Changing Chart SourceData in VBA
Can anyone spot where I'm going wrong? I'm trying to
change the source data in code so it only shows upto the
last cell that has a value in it. My code at the mo is..
Dim intActiveCell As Integer
Dim strCell As String
Dim strrange As String
If ActiveCell <> "" Then
Do Until ActiveCell.Value = ""
strCell = "R" & ActiveCell.Row & "C" &...import chart of acount
I use GP7.5 I export chart of account to excel sheet and modify but i don't
know how i can import agine to new company please is there any way to make
thanks for help
If you have Integration Manager, then you would find it to be the easiest
tool to use. If you do not have it, then the data can be loaded using SQL
Server tools and other products that work with SQL Server. However, if you
are not familiar with these tools, you should get help from somebody who
Charles Allen, MVP
> I use GP7.5 I export chart of account to e...switching investment charts in microsoft money plus deluxe
I'm using Microsoft Money Plus Deluxe 17.0
As in Money 2004 clicking on a listed investment on the Home tab goes
directly to a price chart. In the earlier program I could switch quickly
between investment charts using a drop down list on the chart page. In money
plus deluxe 17.0 I have to go back to Home first or the Portfolio tab. Can I
make this work as before? Thanks for any help.
"Dave K" <p_sellars-at-hotmail-dot-com> wrote in message
> I'm using Microsoft Money Plus Deluxe 17.0
> As...Help with Lookup #2
I have an excel worksheet that has approximately 20,000+ records. I
would like to classify these recorded based on two columns. The first
column's name is "YB Description" and the other is "Sold Date". The YB
column mainly contains 4 digit numerical values, with approximately
300-400 records that are text, ie. "classified", "not verified",
"public use". The Sold Date column is pretty self-explanatory, all the
records are dates with the following formatting - M/D/Y. What I would
like to do is create a third column called YB/Sold that classi...Help with ACT! to CRM migration
Hi to anyone that can help.
I am trying to do a trial data migration from our ACT! database to MSCRM to
see what it will look like. I have installed the migration framework and
appear to have CRM running fine on a server in our network (no errors on
install and all windows appear ok).
Since I do not have a strong database background I was wondering if someone
could confirm what I believe is MS's way of migrating my data accross.
I have exported the data from ACT! to a text file. I imported this into
excel and repleaced the Free/busy data with a unique number for each record.
I the...Multiple 2d charts in a 3d display
I'm trying to get a visual representation of a database of info regarding
loan analysis using a line graph. I want the data to show line items of
widely varying values, and the lines I have come out flat in some instances
because the y-axis is calibrated for up to six figures for some values, but
single digits for others. Is there any way to create several 2d charts, then
"stack" them up on a non-contiguous z-axis?
...Enhancing pie chart with pointers
Belated thanks to Andy Pope for guidance on my problem, which was to
display two 'needles' on a circular chart - like a traditional
barometer - and to colour the sector appropriately.
This post is also to record the points I needed to understand, to
1. 'Chart Type' belongs to a series, not the Chart. (This isn't
evident from the user interface, although I guess the pre-assigned
combination charts presented offer that promise.) So a pie chart and
an X-Y chart may be happily belong to the same chart object.
2. The axes of such a combination pie chart / X-Y ...Need help backing up OL2002 items (or folders)
"If you want to create a folder to which you can drag items for
safekeeping or to distribute to another computer.
Create a new data file (.pst) and drag items to it. If you used the
default name for the folder when you created the data file, the folder
will be called Personal Folders . In the Folder List (Folder List:
Displays the folders available in your mailbox. To view subfolders,
click the plus sign (+) next to the folder. If the Folder List is not
visible, on the View menu, click Folder List.), drag any item from your
current folders to the new folder. Press CTRL...Help with Links to Files
I have a file in Word 97-2003 compatibility mode. When I select the Office
Button / Prepare I see an option to Edit Links to Files. If I convert the
file to 2007 format the option for Edit Links to Files is no longer there.
Where did they go?
This is strange. The Edit Links to Files option should be available even if
you save in Word 2007 format. Are you sure you didn't inadvertently break
the link to the automation object?
You could press Alt+F9 to see that the field code for the object is still
intact. (Note that you can only see the field co...Pie charts #11
I am trying to create a pie chart to add up to 100%. I have 2 values which I
have calculated as students results from tests and I would like to have a
third series which is 100-(the 2 test figures). Can this be done on a pie
chart series range or must I add another cell on the spreadsheet to calculate
this option and then uses these 3 figures as the series for the pie chart.
You need to calculate the 3 values before charting them.
Andy Pope, Microsoft MVP - Excel
"HillsinHolland" <HillsinHolland@discussions.microsoft.com> ...Problem with empty cells when creating chart using vba
I am facing difficulties to create a chart from a sheet containing empty
cells (I use Excel 2003 SP2). My sheet looks similar to this:
A B C
2 0.2 25 34
3 0.3 23 27
4 0.4 24 6
5 0.5 25 16
6 0.6 27 21
Column A contains data (some depth in my case). Each cell in column A
contains data. Column B and C contain some measurements made at the depth
indicated in column A. I need to combine two graphics on one chart: the
content of B in function of A and the content of C in function of A.
The ...Flexible Y-Axis in a Waterfall chart
I have created a waterfall chart based on the following website
The chart shows the changes from Budgeted Revenue to Actual Revenue.
The chart is based on revenue numbers on a regional level with a drop
down to select any country within the region also. For eg. The Budgeted
Revenue is $50m with a variance of +/-2m to arrive at Actual Revenue.
Inorder to amplify the impact of the changes, I have set the Y-axis
scale to start at $47m. The changes (Plus and Minuses) become too small
to have any impact if the scale is set to sta...password
I have problem with Microsoft Outlook XP. Very often
Outlook won't remember the password.
I am having a similar problem. Using Outlook 2002 (XP).
I have several POP3 accounts, and Outlook requires the
passwords every time. I've tried everything, and it
still forgets them.
Thanks to anyone that can help.
>I have problem with Microsoft Outlook XP. Very often
>Outlook won't remember the password.
Earlier reply had the incorrect e-mail address. This
address is correct.
>-----Original Mess...Customizing Chart Type
I have a a data that has 6 series or coloms of
information - I need to create a bar chart that stacks the
first 5 series and will allow me to have a line series.
The options in the present custom template - only allow
for a non-stacked bar...Can anyone tell me how to do this?
So make your own combination chart. Make a stacked column chart with
all of the data, then select the one series you want to change, choose
Chart Type from the Chart menu, and select a different chart type for
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Ex...Help w/ Accounts
I have Outlook 2003, I used to have four email accounts in Outlook. One of
those accounts was set up to check the email but leave the original in the
server. It was working fine until all of a sudden it started downloading
the same email twice and deleting it from the server. I deleted the account
from Outlook, but it is still downloading the email from that account. I
went to Email accounts and I don't see that particular email account listed
Does anyone have any idea how to get rid of this "invisible" email account
that does not show up in the email accounts an...two charts on one chart page
I have made multiple line charts and have placed them each in their own
chart sheet. I am trying to figure out if it is possible to have 2 or even 4
charts posted in one chart page. The only way I see to do this may be to
copy and paste and resize the charts or possibly to paste them in the
worksheet. I ultimately just need to be able to print out 2 or 4 charts on a
kd a �crit :
> I have made multiple line charts and have placed them each in their own
> chart sheet. I am trying to figure out if it is possible to have 2 or even 4
> charts p...