When I am in one cell highlight another
When I am in one cell highlight another. Lets say that if my cursor is in
A1 I want D1 highlighted or with another cursor on it.
Then if I move to A2, D2 should be the one with another cursor or highlighted.
Thank you for your help,
Jose Juan Diaz
hi, Jose Juan !
> When I am in one cell highlight another
> ... if my cursor is in A1... D1 highlighted or with another cursor on it.
> ... if I move to A2, D2 should be the one with another cursor or highlighted.
'put' a cursor on non-active-cell... [I don't think it's possible] :(
to highlight 'D' wh...Cells print so small I cannot read numbers. How do I fix?
I have been working with page break. Now I have the grid on 1 page..but it is
far to small to read. now when I try to spread it back to 2 pages, it just
takes the same tiny microscopic type and spreads it into 2 pages. I am stuck
printing tiny type. How can I get the grid cells back to a size that is
It sound like you have selected Fit to 1 page in File > Page setup > Page >
Scaling. Either select to fit it to 2 pages or select Adjust to 100% size
In Perth, the ancient capital of Scotland
and the crowning place of kings
Repl...automatically close second workbook 12-16-09
i have put the following code in to workbook 'A' to close workbook 'B' but it
does not close book 'B' there is no error message
Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
Several of us have tested your code..........both workbook_open which opens
B.xls when A.xls opens and the workbook_beforeclose code.
Works fine for me.
All I can think of is that you are opening B.xls in a separate instance of
If t...Linking Combo box to pivot table?
I have a pivot table which has teams on the left, months on the top and a
count of the calls in the data area.
What I would love is that if I could have a combo box on a worksheet which
when I select a team from its list it only shows me that teams data in the
Is this possible please??
Windows 98 + Office Pro 97
You could move Team to the page area of the pivot table.
Select a team, and the pivot table will only show its data.
> Hi All,
> I have a pivot table which has teams on the left, months on the top and a
> c...Process all cells in a (user) selection
I am using this code to give me cell by cell access to a code defined
Dim aCell As Range
For Each aCell In Sheet4.Range("A4:A34")
' Do Stuff Here
which processes every cell in the A4:A34 Range
How do I do the same thing for a selection drawn by the user before
pressing my 'Process' button ?
On 05 May 2010 11:10:21 GMT, Isis <isissoft@NOSPAMbtinternet.com> wrote:
>I am using this code to give me cell by cell access to a code defined
>Dim aCell As Range
>For Each aCell In S...Where Can I Find The Icon For A New E-mail Message In Outlook?
I've created the shortcut "C:\Program Files\Microsoft
Office\OFFICE11\OUTLOOK.EXE" /c ipm.note for my Outlook to open a new
message but it assigns the Outlook Icon...
Assuming you are using an English version Outlook 2003, you might find what
you are looking for at:
\Program Files\Microsoft Office\OFFICE11\FORMS\1033
"Justern" <email@example.com> wrote in message
> I've created the shortcut "C:\Program Files\Microsoft
> Office\OFFICE11\OUTLOOK.EXE" /c ipm.note for m...think cell program
is anyone familiar with a program called think cell? Any thoughts?
(powerpoint v 2003). Is this an add-in?
It's very good. You can "try for free" from their website:
Recent interview with one of the founders on Indezine:
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/3...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...Outlook 2003
I used to be able to do this in Outlook 2000. The string will be in either
the subject or text body...or both. For example: looking for an email
message about a specific invoice number 12345. Now, it does not find the
number even when I know it's there....and can find it by hunting on my own.
Thanks for any help you can offer~
"Hello_It''''s_Me-CA" <HelloItsMeCA@discussions.microsoft.com> wrote in
>I used to be able to do this in Outlook 2000. The string will be in either
> t...IE8 was deleted from my windows 7 and I cannot find correct downlo
I have a two month old Toshiba and deleted IE8 because of crashes. Trying to
find the correct download to reinstall. The IE8 homepage just says it is
included in windows 7 but does not show the download file....... ARRRG. Tried
Vista IE8 download file but message says it not the correct operating system.
On Sun, 21 Mar 2010 20:50:01 -0700, pawntonian
>I have a two month old Toshiba and deleted IE8 because of crashes. Trying to
>find the correct download to reinstall. The IE8 homepage just says it is
>included in wind...Money plus Deluxe Where do I find Balance sheet and Profit and Los
I have Money Plus Deluxe ver 7.0120.1415 My new accountant asked me to print
out the balance sheet (aka Assets, Liabilities, and Equity) and the Income
statement (Profit and Loss) reports? Where do I find them? Does Money Plus
Deluxe have them?
In microsoft.public.money, bigwahoo wrote:
>I have Money Plus Deluxe ver 7.0120.1415 My new accountant asked me to print
>out the balance sheet (aka Assets, Liabilities, and Equity) and the Income
>statement (Profit and Loss) reports? Where do I find them? Does Money Plus
>Deluxe have them?
Go to the Reports list, and look around. T...Newbie Cell Reference Question...
I apologize if this question has been answered before, but I'm no
quite sure what to search for as I'm not very good with excel.
I'm making a spreadsheet where one sheet references another. I'll tr
to explain this as best as possible....
I'm creating a spreadsheet for a fantasy basketball league. I have
"Data" sheet that contains data for all players. I have another sheet
"Teams" that has all the players on each team. Column B contains th
players name, and column C contains a number that corresponds to th
row this player is on in the dat...can't find form
i have a command button on a form [frmMainMenu] that when clicked, closes
that form and opens another [frmFixtureSchedulePrintOptions].
The 2 share the same table as a record source, so i'm doing this to avoid
the code behind [frmMainMenu] reads like this (below), and functions
stDocName = "frmFixtureSchedulePrintOptions"
DoCmd.OpenForm stDocName, acNormal
on the new form [frmFixtureSchedulePrintOptions], there is a command button
to save to close itself, and open the previous from [frmMainMenu], and the
...How to find addresses stored in Favorites folder
My toobar shows a button for adding to favorites but I can not find my
favorites list anywhere after I add them?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
"Zuli" <Zuli@discussions.microsoft.com> wrote in message
> My toobar shows a button...Cell background shading in Excel
Why is it that the background shading colors available
under the Paintbucket Icon chjange from file to file?
Also, how can I add some of the colors to the paintbucket
that are availabe under the format/cells/pattern pulldown?
Colors are a Workbook-level property, so you can change the color
palette for any workbook. Choose Tools/Options/Colors... and modify the
colors to your hearts' content. You can also import another workbook's
color palette from that dialog.
Note however, that there are only 56 bins in the color palette, so you
can only use 56 colors at a time. The paint b...Linking Drop-down list to worksheets
I need 20 dropdown list on the worksheet. some of drop-down lists has the
same values. I need a list thats has one set of names and worksheet has
another set of names. Here is a example want I need.
LIST names Worksheet names
Red - Black 770rb
My list will have 15 items in each list. When user click on the color it
would take them to that worksheet.
What is best way to do this?
...Sum every other cell?
I own a used-book shop. I have an Excel SS to track how many books pe
day I sell in each of 28 categories and the $$$ I take in for eac
category. So there's two columns for each day: #books & $$$.
therefore want to add every odd-numbered cell in a row to get the tota
number of books for a category in a given period of days and ever
even-numbered cell in the same row for the the total $$$. Is there
simple formula or function for this
bookmanjb's Profile: http://www.excelforum.com/member.php?acti...find/replace
I'm trying to find all the 0's in a certain column and replace them
with a blank. However, when I hit the "find next" it finds a number
that's not 0. For example, it'll find the number 126.423 which
doesn't even have a 0 in it at all. I don't what the problem is.
Is 126.423 the result of a formula?
If you select the cell that contains 126.423,
what does the Formula bar display?
"LLama" <firstname.lastname@example.org> wrote in message
> I'm trying to find all the ...How do I populate the "Find" dialogue in Word with the contents of the clipboard?
I tried, and failed to create a macro.
(I do a procedure hundreds of times every day so wanted to automate
I press Control-F (to open the 'find' dialogue) and then press Control-
V (to paste the contents) into the dialogue. As you can see from the
code below, when I recorded the macro, it used '2022' (which is what
happens to be in my clipboard right now) but I want it to use the
Is this possible? I hope I've explained the problem properly.
Sub FindWhatsinClipboar...File folder info. in Excel workbook?
Good day all. Excel 2007. XP Pro.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2 there
would be...how do I find the equation of a line using a scatter plot?
I am taking a chem lab and right now we are studying rate laws using
kenetics. we had to graph the results of our experiment and then find the
equation of the line. such as y=mx+b but i cant fiugre out how to do it. or
if i am supposed to put a trend line in the graph, but if that is what I am
supposed to do how do I find the equation of it?
First: to make trendline. Right click on the data in the chart; use Add
trendline; specify Linear; on Options tab, check shoe equation
Secondly:To get slope and intercept:
Let's say you x-values are in A2:A11 and y-values in B2:B11
for slope us...FootNote links and PDFs
Does anybody know how to get Word 2003 SP3 with Acrobat Std 7 to generate
PDF links... I know this is more likely an Acrobat question... figured I'd
check in here.. 900 page document with lots of foot notes, and when you
convert it it removes the links Word inserts...
Thanks for anything you can do.
There's more than one way to create a PDF in Acrobat 7. If you just print to
the Adobe PDF print driver, you will not get any hyperlinks. However, if you
open Adobe and select Create PDF - From file, you should get the links you
If you have the Ado...MERGE CELLS
I have Name, PO Box, street address, city, state, zip across a row in 6
I want to have this format in 1 cell:
City, State Zip
> I have Name, PO Box, street address, city, state, zip across a row in 6
> seperate cells/columns.
> I want to have this format in 1 cell:
> PO Box
> Street address
> City, State Zip
You do realize that this will screw up your ability to sort the data.
A better solution would be to describe what you want to do with the
data. You may not need it in the ...How do I format a cell to auto date
I would like to have a date automatically enter itself each time I open the
spreadsheet. Is there a way to do this? Any help would be appreciated.
Use a function like this one for todays date
Regards Ron de Bruin
"George" <George@discussions.microsoft.com> wrote in message news:7EF21130-EBD9-41C2-8CB5-5723BE40CBB1@microsoft.com...
>I would like to have a date automatically enter itself each time I open the
> spreadsheet. Is there a way to do this? Any help would be appreciated.
...Repeating columns cuts off merged cells
I hope you can help because I can't find a solution to this one.
I've got a two page spreadsheet (side by side) and I'm trying to repeat
columns A & B because their row headings on the left and should only
appear when printed (split onto two pages) (as in print setup > columns
to repeat at left > $A:$B),
B57:I57 are merged and wrapped (another grief that merged wrapped cells
don't auto height, but that's for another day) and so are B58:I58 and
B59:I59 (footer things).
...... and when printed,
B57:I57, etc. cuts off on the second page and...