how can you view cells from different worksheets in to one sheet,.
I have multiple worksheets, more than 200 of them, and i wanted to summarize
some cells in to one sheet, I know how to do it by entering the code manually
(='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that
like drag or something?
You can use this macro myasin
Regards Ron de Bruin
"myasin" <email@example.com> wrote in message news:07759D01-70FE-416A-B54B-009646C2C365@microsoft.com...
> I have multiple worksheets, more than 200 of them, and i...picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles
and if I move the handles some, the picture will show up. However, it
will not show up in print preview at all or page break preview. I can
open the same file on another computer and it will show up fine.
Any help would be appreciated.
Tools -> Options ->General
Do you have "Show All" selected for Objects?
> I have a picture that is in an Excel worksheet. I can see the handles
> and if I move the handles some, the picture will show up. However, it
> will...Embedded pictures
I noticed that the when we set the picture property of a button or another
control as embedded, it takes a lot of place.
Is there an explication that show why the Access file encrease in size by
more than the picture size (even if it is a bitmap, a format that is normaly
An mdb without picture would take 4 MB
the same file with pictures would increase to 40 MB with only 400 KB of
pictures. In JPEG format.
Is it because Access uses a non efficient compression to include the image
Thank you in advance for any suggestion!
PS: I know that I can set the pictur...Find a empty cell in next column
Dave helped me with this before, now i need more help.
I use this code to find a column called PoF and the numbers written in the
cells below it. This code work in every row/column (i dont need to name it).
PoFRow = 0
PoFCol = 0
On Error Resume Next
PoFRow = Worksheets(2).Range("PoF").Row
PoFCol = Worksheets(2).Range("PoF").Column
On Error GoTo 0
If PoFRow = 0 Then
MsgBox "No range named PoF on worksheet:" ' & .Name '
Set numberPoF = Nothing
On Error Resume Next
Set num...Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000
or Outlook 97. I'm using XP Home.
Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service
Scott Atkins MCSE, MCSA
Partner Technical Lead - Outlook
Microsoft Technical Support
for Platforms and Business Applications
>Subject: Pictures don't...Need event macro to tab past a (calculated) cell
I have an Excel 2003 List (aka Table in Excel 2007). There are some
protected (calculated) columns that I don't want users to enter data into.
But I can't protect the sheet, because that prevents users from entering a
new record at the bottom of the List.
Does anyone have a suggestion on how to deal with this? I'm thinking of
using an event macro invoked when user tabs out of say column C, which makes
the selection skip the cell in column D and go directly to the cell in
column E. I guess I'd have to use Worksheet.SelectionChange. But I don't
know how to do...Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the
slide and when I try to format it it is impossible to get it back to the same
pic I am attempting to add. If I am trying to add a pic I might only get a
nose or a blade of grass instead of the original picture from "My Pictures".
Reduce the zoom to 10%. Coul be a too large image
"PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le
message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com...
> When I add a pic from "My pictures" t...picture in picture
Have to digital pictures & would like to put a couple of people on one
picture into the other picture. How do i do this? Anyone got any ideas? TIA
"ted medin" <firstname.lastname@example.org> wrote in message
> Have to digital pictures & would like to put a couple of people on one
> picture into the other picture. How do i do this? Anyone got any ideas?
Well not with Vista. You need a Graphic editing application.
The Gimp may be able to do this. (It's free, Open Source but is a bit tricky
yo get to lear...Convert Social Security text to number?
I would like to convert a text social security number (###-##-####) to a
numerical format (#########) so that it can search using vlookup functions.
Any help is greatly appreciated.
it depends on whether it is numeric formated with the dashes or Text with the
goto <format><cells><number> and select general
if the dashes are still there it is text.
select the cells and use find replace (Find the dash replace with nothing)
the cells will still be text, so enter 1 in a cell copy it select the SSN
cells and paste special Multiply
"Joe" wro...Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see
the frame. The same thing when I load a publisher file created by someone
else. All the inserted pictures does not show. View>pictures is set to
Any suggestions for a solution?
Read the third FAQ here
Mary Sauer MSFT MVP
"Thor" <Thor@discussions.microsoft.com> wrote in messag...Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again
a picture. Some of these will have 8 to 10 pictures with text under each
picture. But when I send it out it is received with all of the text in a
group and the pictures are all sent as attachments. How do I get my e-mails
to send the pictures and text the way I receive them? Thanks for any help
you can give me. Bob
...Text over 255 characters won't display
I understand from other posts that the limit on the number of characters in
a text cell is large (32K or 64K?). But whenever I enter more than 255
characters, the cell doesn't display. I just get a single line of #s. The
cell is formatted as text with word wrap, top aligned, and the row height is
auto-fit. Even if I manually change the row height to some large number, it
doesn't help. I've looked in vain for a setting that might affect this, but
can't find one. I have had Excel files sent to me by co-workers where this
does not happen, and compared my setting with theirs....blinking or flashing cell or cells
I want a cell or string of cells to flash or blink constantly when i open the spreadsheet. It does not matter if the text or background blink or flash. Is this possible?
Possible? Yes. Recommended? No. Why? Slows down the
processing time. But a search through the google archives
yielded a lot of solutions. Here's one from MVP Chip
>I want a cell or string of cells to flash or blink
constantly when i open the spreadsheet. It does not
matter if the text or background blink or flash. Is this...Insert username into text box
I am using the fOSUserName functionality in my DB. I would like to use it to
dynamically preface comments a user types into a text box.
Scenario...user opens a ticket form, starts typing a comment in the text
box, and Access automatically inserts their username in front of their
comments (in bold typeface if possible) followed by a couple spaces, or a
space dash space.
Any ideas? Thanks!
Use the AfterUpdate event of your text control (ex. control name =
Me.Comments = CurrentUser & " - " & [Comments]
Microsoft...Formatting Cell #2
I have a block of text that I auto corrected and shows
corrected in the Normal view. However, when I preview the
sheet there is space between cell above it and the text in
my cell. I want the text to come all the way up against
the cell above it. How do I fix this?
Format-Cells-Alignment tab. Set the vertical text alignment to "top."
"Mike" <email@example.com> wrote in message
> I have a block of text that I auto corrected and shows
> corrected in the Normal view. However, when I preview t...Picture Link
Appreciate some help here and thanks in advance.
I link my pictures to the following folders
C:\Documents and Settings\MyName\Desktop\Picture.jpg
C:\Documents and Settings\MyName\My Documents\Picture.bmp
If Me!pic1a = "X" Then
Forms!startpg!fmpPic!Img.Picture = ""
Forms!startpg!fmpPic!Img.Picture = Me!pic1a
It works on my PC but when I copied the program to another PC, it does not
This is because of "MyName" and the other PC has a different name. Is there
a way to ignore "MyName" for any PCs
"ChoonBoy&quo...Picture in header
How do I get a picture in the header?
This was added in xl2002.
File|Page setup|header/footer tab|custom header
There's an icon that looks like a picture near the far right.
> How do I get a picture in the header?
If you are using a version of Excel before 2002 then check out:
for a workaround.
"Dave Peterson" wrote:
> This was added in xl2002.
> File|Page setup|header/footer tab|custom header
> There's an icon that looks lik...outlook viewable text size
I have an issue where the viewable text size in Outlook is too large- when I
open a msg, its normal, what everyone typically sees. But when I create a
new msg or reply or fwd an existing msg, the viewable size gets huge. The
font size stays the same (eg, 11), but in my msg it appears to be size 64
(font format stays 11 though). Its like looking at a normal sized font
through a giant magnifying glass.
This first happened when I was editing the viewable size in Word (all apps
2007 on Vista x64). Alt-tab back to Outlook and I must have moved my mouse
scroll bar and the font view ...Button Text
Can you change the text of a dialog button during run time ?
There doesn't seem to be anything about doing it under the MSDN CButton
"Lordy" <firstname.lastname@example.org> wrote in message
> Can you change the text of a dialog button during run time ?
I think you can use SetWindowText.
Jeff Partch [VC++ MVP]
As mentioned by Jeff, you can use SetWindowText. CButton is derived from CWnd and
SetWindowText is a public method in CWnd. Alternativcely, you can use SendMessage
Ajay K...Extract data from a cell after a constant value
I have a spreadsheet that contains 1 column of data, if the cells of the
column are the city names and populations of towns in the following format:
Appleton, Wisconsin (WI) (pop. 70,087)
The 'pop.' is always present.
I want to extract just the population number (ie: 70,087) from these cells
into another cell.
What is the simplest way to accomplish this?
On Sun, 19 Aug 2007 12:29:37 -0500, "Wolfman" <email@example.com> wrote:
>I have a spreadsheet that contains 1 column of data, if the cells of the
>...how to change what text and feilds r sent as a "return Receipt"
Would like to change what is sent when I send a Return Receipt to someone.
can't seem to find this anywhere i any documentation
> Would like to change what is sent when I send a Return Receipt to someone.
> can't seem to find this anywhere i any documentation
The sender of an e-mail with the headers requesting a "read/delivery
receipt" cannot specify how that acknowledgement e-mail is composed.
Ok, Where is this information pulled from? At two locations email is sent and
recieved. when sent from M1 a reead receipt is requested. At M2 the m...Text to Columns issue
The accounting program that I use does not have a well formatted excel
download, so it is better to dump the data into notepad and then format it.
I have created a macro to do the formatting for me. The only trouble is that
if I open excel, and I run the macro, if I want to put new data in the file
to run the macro on, excel has already converted the data to columns, and my
macro no longer works correctly. The only way I can fix it, and have all of
the data show up in column A (with | as a delimiter) is close the entire
program and launch it again. Does anyone know ho...Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the
catalog through the Excel worksheet. When the worksheet is imported, all of
the pictures left-justify in the picture frame. Can this be centered?
...How do i change the cells in a column at the same time in Excell?
You post is way thin on details and to insure you get some goo
feedback, it is important to take the time to be a specific as possibl
about what you want to happen.
That being said; here is an example of changing an entire column'
If you want to apply the same formatting to all the cells in a column
click on the column letter A,B,C........, you will notice that th
entire column is highlighted. Now, go straight to Format>Cells an
begin selecting the formatting changes you would like. These change
will be applied to the entire selected column.
Hopes this helps,
...Counting cells with specific month in
How can I count the number of cells in date format which contain a certain
How can I count the number of cells in column A which contain an October
date. The answer here would be 2.
Try this formula (set the month number, 10 in this case, as needed)...
Rick (MVP - Excel)
"JRD" <JRD@discussions.microsoft.com> wrote in message
> How can I count th...