Macro on cell content
this must be a common problem, and I thought I found the solution, but
it doesn't work ... I'm probably missing something very simple.
I want to execute a simple VB function in one cell, taking another cell
as Parameter. Both, parameter cell and function result are strings. For
A1: "this is content of cell A1"
and Convert is a VB function
Function Convert(content As string) as String
' do something depending on content
Convert = "result-string"
However, I always get a #NAME? Error in cell A2.
The ide...Make merged cells in clipboard paste as unmerged?
If a user copy merged cells from another sheet, I dont' want to allow it to
paste as that, but just paste as a textstring in the selected cell.
Anybody having a sub macro to share?
use 'Edit - Paste Special - Values' for inserting your content
> Hi all,
> If a user copy merged cells from another sheet, I dont' want to allow
> it to paste as that, but just paste as a textstring in the selected
> Anybody having a sub macro to share?
I'm ...Number cells won't reformat / sort
I'm dealing w/ a spreadsheet composed of cut-and-pasted rows from 2
sources (A and B) both originally exported from Filemaker at different
When trying to sort the data by a "Record Number" field, the 2 datasets
remain split and will not integrate.
In other words, instead of the sort result being something like:
They look like this:
The 2 groups remain separate and sort individually.
It gets stranger, though. If I reformat the column to, say, a percent
or a currency r...Selecting Multiple Cells.
I know how to select a range of cells by specifying reference in nam
A10:A20 (The range of cells in column A and rows 10 through 20)
5:5 (All cells in row 5)
However, I am attempting to select every third cell going down colum
A, beginning with A3. I can enter
A3, A6, A9 (This will select just those cells.)
Is there a shortcut I can use to continue this pattern of every thir
cell indefinitely? (I actually need to select every third cell down t
Thank you for any assistance
Message posted from http://www.ExcelForum.com
Here's one way:
1. Put this in ...cell watch function in excel 2001 for mac?
is there a cell watch window in excel 2001 for mac? if not is there
way to download an add-in for it
mike10's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1441
View this thread: http://www.excelforum.com/showthread.php?threadid=26193
In article <firstname.lastname@example.org>,
mike10 <email@example.com> wrote:
> is there a cell watch window in excel 2001 for mac? if not is there a
> way to download an add-in for it?
MacXL's VBE do...Getting photos to print in an image field
This is Access 2007. In my report I have an image field (9 x 6.77 cm).
It exists in the detail section of a subreport and snakes across then
down. The onPrint event for that section reads:
Me.imgPhoto.Picture = Forms!frmProfiles!txtPath & "\" & Me.txtPhoto
My problem is that Access doesn't print all the photos. I suspect it's
a size issue as if I reduce the resolution of the photos to, say, 800
x 600, then they all print. However, the resaulting print quality is
not nearly as good as the original resolution
So: is there a way to force Access to be patient and ensur...Getting e-mails
Prior to 2007 I would simply export e-mail messages, contact etc to a .PST
file or simply copy that file over. But I think it different starting with
Outlook 2007, but I using Outlook 2010. What do I need to do to transfer
over the e-mails? I also came across a program called Mail Store home. What
is the best way to do this?
Best method there is:
You should bookmark this website. It's excellent and will answer most, if
not all, of your Outlook questions.
"klafert" <klafert...How to get the size of an icon?
I need insert an ActiveX conctrol in the CRichEditCtrl.
sizel.cx = the ActiveX conctrol'width;
sizel.cy = the ActiveX conctrol'height;
reobject.sizel = sizel;
The ActiveX conctrol can display an icon.It'width is the icon'width.
How to get the size of an icon?
Use ::GetIconInfo ...getting players records vs. other players
Hi I am having trouble doing this. Here is what i have. I have a table
that shows the date, winner, and loser. I then have 2 queries that
counts the number of times Player A won vs. Player B, and then how
many times Player A lost to Player B. I then combine thsoe 2 queries
and it works fine provided Player A and Player B have at least 1 win
and loss vs each other. If not, nothing shows up when i combine the
queries So what I need is for it to show that Player A is 4-0 vs
Player B and subsequently Player B is 0-4 vs Player A. Can someone
Player Team Won Oppon...Putting a different character in a cell
Okay here is the problem: We are setting up an Excel worksheet to figure
out productivity of employees. I am able to set up a cell to average
another range of cells. Example would be that Cell J3 will average
Cells C3 - I3 (=AVERAGE(C3:I3)). Now I have two questions... Is there a
way to make Excel put a character in Cell J3 where the formula is
instead of a blank cell OR even better I would like to create another
worksheet that will take MULTIPLE cells linked to the first worksheet
with the average formula in it to then do -another- average of the
cells if there is information in the cells. A...copying content of cell into other cells casually
I preparing about 3000 tickets for an Italian tombola. A row of 15
randomly chosen different numbers from 1 to 90 (e.g. 8, 20, 22, 34, 40,
43, 51, 55, 62, 72, 74, 84, 85, 90) needs to go nicely into a table
quite casually. The table (three rows high and ten columns long) which
are the tickets that will be sold at the tombola will look like the
| | | 20 | | 40 | | 62 | | 84 |
| | | 22 |34 | 43 | 51 | 63 | 72 | 85 |
| 8 | | | | | 55 | | 74 | 90 |
Numbers needs to be in these columns as players can see easily if they
have go...checkbox linked to a cell
I am programatically trying to add a checkbox.
but it looks like you have to give pixal locations
ActiveSheet.OLEObjects.Add(ClassType:="Forms.CheckBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=111.75, Top:=197.25, Width:=85.5, Height
is there a way to add a checkbox and give the cell row / column?
Dim myCell As Range
Dim OLEObj As OLEObject
Set myCell = ActiveSheet.Range("b3")
Set OLEObj = .Parent.OLEObjects.Add(ClassType:="F...Getting contents of a cell when cell reference is in the sheet
If I have a cell reference in a cell, how could I get the contents of the
cell instead of the cell reference again.
A B C D
How could I see the contents of cell A2 using the information in cell C3.
I'm matching one number with another in different worksheets and want to get
a value from the same row as the match. I can get it to return the address of
the data I want to get, but can't get the data.
Incorporate INDIRECT()... i.e. =INDIRECT(A2) will return the contents of A2.
"A Nelso...editing cells automatically???
Why is it that some spreadsheets will not allow you to edit cells
automatically when tabbing between windows? i.e. some spreadsheets will
require you to double click in the cell to continue editing once you navigate
away from that spreadsheet.
Not too clear on your problem but............
Is it possible you have separate instances of Excel running with different
Gord Dibben MS Excel MVP
On Thu, 13 May 2010 14:25:01 -0700, yogiiyogee
>Why is it that some spreadsheets will not allow you to edit cell...Formulas within Cell References
I need to use a number that was calculated from a formula in a cel
reference. Here is the situation: I have a large spreadsheet tha
changes periodically. I need to count the number of items in tha
spreadsheet(i will use COUNTA - already works) and then take tha
number and use it as a row number in a cell reference like this:
In cell H1: =COUNTA(A2:A9999)
Then take that number in cell H1 and insert that into say $J$XXXX wher
XXXX represents the number in cell H1.
I'm looking to increase the calculation speed of the workbook by onl
calculating cells that I need to.
Thanks f...cell font color changes
When i change a cell font to grey in Excel why doesn't it print grey when
sent to a black printer. it only prints grey if sent to a color printer
Because the B/W printer can only print in black.
the color printer can print in colors and to the printer
gray is just another color.
>When i change a cell font to grey in Excel why doesn't it
print grey when
>sent to a black printer. it only prints grey if sent to a
Also, some b/w printers offer a "grayscale" option under Print Qualit
or the lik...how do I keep comments with cell?
I want the comments that I post to stay in the same format and with the same
relationship to the cell that I post it in. Now,when I edit an existing file
with comments, the existing comments float all over the file. I would also
like to be able to reset the existing comments back to their original format.
Code from Debra Dalgleish.......
Reset Comments to Original Position
If comments have moved out of position, you can reset them using the following
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.L...Summing visable cells only
I have a worksheet with 8000+ rows. Some of the rows are hidden. I want to
have a formula at the bottom of the rows that sums only the visable cells
(non-hidden) rows. Any suggestions? (The rows are hidden and not filtered).
=SUBTOTAL(109,A1:A8000) will give you what you need.
"Paully Shore" wrote:
> I have a worksheet with 8000+ rows. Some of the rows are hidden. I want to
> have a formula at the bottom of the rows that sums only the visable cells
> (non-hidden) rows. Any suggestions? (The rows are hidden and not fi...Adding specific Cells Only.
I am doing a tally on what my department has spent the past year. The sheet
looks along the lines of this:
Department Item Use (If Applicable) Cost Benefits Area
Administration Two Pt. Buliten Boards $1,700.00 N1, N2, N3, N4
Medication Refrigerator $600.00 N2
Pictures $500.00 N2
Chairs, Furniture/Equiptment Supplies $7,200.00 North Hall
Courtyard $40,000.00 N1
Courtyard $40,000.00 N1
Rehab OT supplies for centralized groups including supplies foor physical
diabetes Groups/Activities Splints, excercises,
...charting a single changing DDE cell
I have a spreadsheet that captures real time stock data via a DDE link. The
cell captures the last price of a stock as it changes over time. Can you
chart that changing cell as the day progresses. Maybe capture the data and
then chart it or a macro which plots that cell every minute?
You would need to capture the value of that changing cell periodically
in a growing table, possibly in a different sheet.
For example, every time you update it via the DDE, you could run a code
that copies the value of the cell to the last row of the table.
Use a dynamic chart to plot the values in t...How do I get numbers on a colum to stay as I typed them on an exc.
I created a workbook with information to be used for merging to a letter. I
created a heading colum to read "HOURS" and entered the numbers as 1:23.
When I merged the files, the information showed at 1:23:00 A.M. How do I
correct this on my workbook excel file or on the Word document? I do not
want the numbers to be changed to time. Please help!!!!!!
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
Desperate School Secretary...Named Cells In Worksheet
This is probably really dumb:
After assigning a name to a cell or range of cells; how
do you un-name or delete the name?
From menu select Insert.Name.Define
Select the name from list - Delete
"Fred Yager" <firstname.lastname@example.org> wrote in message
> This is probably really dumb:
> After assigning a name to a cell or range of cells; how
> do you un-name or delete the name?
Use Insert, Name, Define. Then, highlight the name and press the Delete
button...Use the same cell from many worksheets to create a chart?
I have a new worksheet for each day, labeled with the date. I want to pull
data from the same cell (like "P-3") in each worksheet and put it into a
Example: On ten worksheets, pull the data from cell P-3 (arbitrarily called
"income"). Then, put that P-3 data into a chart that tracks daily income: the
date itself (taken from the worksheet name) plus the data.
Any idea how to do this?
You need to create a summary region on a worksheet, and use this as the
data source for your chart. See this page for more details:
http://peltiertech.com/Excel/ChartsHowTo/Char...Problem with copying a to from date to another cell
I am trying to enter the first 7 days of the year in one cell.
ie: A1 -> 1/2/05 to 1/8/05
And then I want to drag that down to 53 cells and have it copy in the
ie: A2 -> 1/9/05 to 1/15/05
A3 -> 1/16/05 to 1/22/05
Is this possible?
I would do it by using two separate columns, typing in the two top row
dates, the highlight the area you wish to fill, then Edit > Fill > Series >
Trend..........then when you have the two columns of dates, use a third
helper column with this formula copied down......
=TEXT(A1,"mm/dd/yy")&...Link chart format to a cell
I want to create a chart that changes format depending on value in a special
For exemple a bar chart that for one value have blue bars (the whole chart)
and for another value red bars?
On Thu, 26 Jun 2008, in microsoft.public.excel.charting,
vito <email@example.com> said:
>I want to create a chart that changes format depending on value in a special
>For exemple a bar chart that for one value have blue bars (the whole chart)
>and for another value red bars?
You can't, it's not possible in Excel. But you can have two series, one