Excel file opens with a blank screen
I have an excel file with a few worksheets. Sometimes (But this does not
happen every time) after I run a macro that takes data from other files and
puts it onto a worksheet in the current file, after I save and close the
current file and then reopen the file, it comes up blank. I can still view
my vb code, but I cannot see the actual spreadsheets unless I go to
View-->Full screen and then reduce the view with the minimize icon on the
little toolbar that pops up. What really makes this odd, is that a friend in
another lab can run the macro and open the file at his place with no
prob...variable in a set of values
In SQL, there is a condition IN . e.g. products in (a,b,c). I
want to know whether there exist a same statement in C#. Or maybe I
should use other syntax? Thanks.
We'll likely need some details as SQL is not C#. In particular this is the
other way round. Most collections have a method that allows to find out if
a value is found in the collection.
Try for example :
You could create an array that contains the a,b, c value and then test if
this array contains the products value...
Patric...text on document is really small even though it is set at 12 why?
When I am in a word 03 document the text displayed is really small, even
though the font size is set at 12. Either that or the page is really big
Have you tried changing the zoom rate?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"suzannah" <firstname.lastname@example.org> wrote in message
> When I am in a word 03 document the text displayed is really small, even
> though the font size is set at 12. Either that or the page is...Setting print areas on many sheets
I would like to know if there is a way of easily setting the print
areas in a workbook automatically.
Basically I have a spreadsheet with around 30-50 tabs, depending on
what comes in during the week.
I need a method of automatically setting the print areas to only select
the cells that have data in them, for each tab.
Currently I have to go in each one and do it manually, and this takes
Could anybody suggest a formula or VB code for me to use?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet message...To set up a command that will insert a row, every fifth row?
Using Excel, how would you set a a command to auto enter a row, every fifth
row of your data sheet?
shanespop2b, here is some code that will do it, original code by Dave
Peterson, modified to your needs
'will add a row after every 5th row
'By: Dave Peterson
Dim iCtr As Long
Dim LastRow As Long
Dim myRng As Range
LastRow = .Cells.SpecialCells(xlCellTypeLastCell).Row
Set myRng = Nothing
For iCtr = 5 To LastRow Step 5
If myRng Is Nothing Then
Set myRng = .Cells(iCtr, "A")
...Forcing Caps and Spell Checker Settings
I have two questions.
1) How do you set the cells in Excel to auto change all
letters entered to be all caps regardless of how it was
2) How do you set Spell Checker to run after every time
you exit an individual cell in Excel?
Question 1: Press the Caps Lock key?
Question 2: You will have to use programming code...
Right-click the worksheet tab, select view code.
Delete all text in the large window on the right.
Paste in the following:
Private Sub Worksheet_SelectionChange(ByVal T...How to list all the individual mailbox permissions set by owners?
Is there a tool/way in ESM for the Ex Admin to list all the permissions
which each individual user has set on their mailboxes, i.e., giving
other users access to (parts of) their mailboxes?
I'm looking for something like PFDAVAdmin for mailboxes.
The reason is I need to move a few hundred users from a 5.5 site to a
200X site in different orgs. Fortunately, all the users are in the same
AD forest/domain so the same Windows accounts are used on both sides.
The Mailbox Migration Wizard will move the data but not the
ESM will not do this. However,...Lost password setting after closing outlook 2002.
i configured my outlook 2002 according to my ISP
instructions. Unfortunately, everytime i close outlook i
lose my password setting. I went to microsoft.down and
downloaded all the sp and patches. Does anyone experience
with their version of outlook 2002.
...Setting the color of a cell from a cell
I have two worksheets with similar data. In fact they are almos
identical. I would like to use a third worksheet to show the cell
which are equal as yellow and those which are different as red.
I have made an attempt at writing it, and have searched the forums, bu
can't find anyone trying to do this.
Here the cell formula in 'sheet3'!A1(copied to the whole sheet):
Here is my code for setColor():
Function setColor(R As Range, C As Integer)
For Each X In R
X.Interior.Col...How do I set up dowloading PDF file on web page using Publisher
I am setting up a simple web site using publisher and what to give browsers
access to PDF files of media articles etc. How do I set up a link on a web
page and where do I put the main PDF file?
On your webpage put a text line for the file, i.e., Get this file. Highlite
the word FILE or words GET THIS FILE. Right click select Hyperlink and type
in the path to where you are storing the pdf file, i.e., downloads/file.pdf
Create the folder DOWNLOADS on your website, upload file.pdf into the
(uppercase is to clarify suggestion and not necessary for actual procedure -
al...lookup in vba
I am trying to write a vba code that accomplished the following exce
can anyone help
I have wrriten the following
Range("j1:j5"), Range("l1:l5"))) = True Then ....
but when I run I get an error messege telling that I can not find th
lookup function, I think its due to the fact that the return is N/
since when I put on a cell that has an answear I get a response
Message posted from http://www.ExcelForum.com
This works for me
In the code below, I am getting an error on the following line:
ElseIf ireply = vbNo And ActiveWorkbook = filename Then
Dim filename As String
Dim ireply As Integer
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Set wb1 = ActiveWorkbook
filename = Worksheets("Amtreference").Range("A2").Text
ireply = MsgBox(Prompt:="Do you wish to create a new batch?", _
Buttons:=vbYesNo, Title:="Create New Service Request
If ireply = vbYes Then
...Explanation of VBA procedure
Could someone please explain what is happening with this procedure .
For Each cell In Sheets("ALL A-C").Range("B25:B1524")
.Offset(0, 1).Resize(1, 6).Locked = .Value
1. Does it mean that the cells in columns C through H are all locked if the
Value in the corresponding row in column B is true?
2. How does this procedure determine if the value in column B is true or
3. How does the Offset procedure work. That is, why Offset(0,1) why not
(0,0). And Resize(1,6) instead of (0,6)?
4. How does the loop do its thing as...always appears an error on screen when send email
when sending message from mic outlook 2000, there always an error appear on
the screen ??
> when sending message from mic outlook 2000, there always an error
> appear on the screen ??
See reply to your other post.
...How do I name a picture as I paste it from VBA? (ActiveSheet.Past.
I want to use VBA (and maybe some variation of the ActiveSheet.Paste
command?) to paste the image on the clipboard into Excel under a certain name
i.e. "samplepicture". I have tried "ActiveSheet.Paste.samplepicture" and
"ActiveSheet.Shapes("samplepicture").Paste" but can't seem to find a good
When you paste, it'll be selected.
Selection.Name = "samplepicture"
"Leitey" <Leitey@discussions.micr...How to set default cell formattiing to vertical alignment = top ??
How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default
format for all new worksheets ?
Thanks again for your help.
Ah, the miracle of computers!... someone also said "To error is human, but
to really screw up it takes a computer!"
Take a look at "default workbook" in XL Help.
In article <563D9BF8-D599-43E6-9383-AB68FC7CBF01@microsoft.com>,
akm <email@example.com> wrote:
> How to set 'Alignment', 'Vertical:' cell formatting to be 'Top' as default
> format for...Setting up a small office network for Outlook
I have an office network of seven PCs and we have just
How do I set up Outlook so that it can be accessed by all
Post more info on what you try to accomplish and what you have available;
Do you want to have them separate e-mail accounts? Do you have 7 accounts
already? Do they need to be able to share data. Do you have a mailserver
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Paul Humphries" <anonymous@disc..."Customized Screen Display" (CTRL-F6) intended to work this way
If I initiate the Touch Screen display in Store Operations POS (by CTRL-F6,
set up the desired displays, and then OK) and then scan in an item for sale,
a dialog pops up asking to accept requested, backorder, etc.
After clicking or pointing to 'accept requested' the item is added to the
list of items in the 'body section' but the Touch Screen menus disappear. I
need to use CTRL-F6 to get the Touch Display Menus back on Screen.
Have I set up the system wrong or is the normal?
Thanks in Advance
This post is a suggestion for Microso...Full screen slideshow under automation
Context is C# or VB.NET Powerpoint control and enforcing a true fullscreen
The "fullscreen" kios mode gives a black band and the top & bottom as well
as the task bar. However, when Powerpoint is directly used then the full
screen is a true full screen.
I was interested on how to invoke a true full screen
Microsoft.Office.Interop.PowerPoint...How to sort to sets of data so that corresponding numbers match
I am trying to reconcile to accounts. I need to sort both sets of data to
each corresponding numbers.
Need to be a bit more specific, and example data would help.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:57B6...Rules wizard set up for rule
I set up the Rules Wizard to send messages with key words in the subject and
or message to a certain folder. I have applied the rule and run the wizard,
but it still isn't applying the rule. Any ideas?
Are you referring to existing messages or new messages that are currently
"enh" <firstname.lastname@example.org> wrote in message
>I set up the Rules Wizard to send messages with key words in the subject
> or message to a certain folder. I have applied the rule and run the
> wizard...(?) Set default font and font size in comments?
How do I change and set the default font and font size for comments?
The default of Tahoma 8 Bold is too small to see clearly,
I want Tahoma 12 Normal.
Thanks and regards,
tinius art mail daught com
From Debra Dalgleish..............
You can change the font size of new comments by changing the Windows OS
(Instructions for Windows XP)
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
Note: this will affect all applications a...setting personalized background for Outlook messages
Rather than using any of Windows background fills or stationary can I use a
file of my own as the default background for Outlook messages? If so how do I
set it so it becomes the default background? [WinXP/Office '03]
> Rather than using any of Windows background fills or stationary can I
> use a
> file of my own as the default background for Outlook messages? If so
> how do I
> set it so it becomes the default background? [WinXP/Office '03]
Create your own HTML file and place it in
%CommonProgramFiles%\Microsoft Shared\Statione...setting up a fresh install with a copied DB
I'm trying to set up a parallel install of GP 8 sp5 and I'm fairly new to
this area so any help would be great, I've got GP installed, a seperate db
copied, and the odbc connection set up between the gp server and db server.
But I get a message saying "The Great Plains SQL Databases have not been
setup for this version of Great Plains...This will need to be completed
before continuing." I'm not sure what my next step is to set up a back up of
the Database? Again thanks for the help.
Doc - Do you have access to KB on MS customer source? Microsoft (MS) has a KB...VBA inserting chr(10) or vbLf
In a for next loop I want to insert at a certain position (below it is
position 15) in a cell chr(10) (is that called a line feed?) to put the rest
of the content on a new line in the cell.
myCell.Characters(15) = vbLf
but that will not work.
What should the code be?
Thanks in advance for your advice.
On Mon, 10 May 2010 12:03:40 +0200, "Jack Sons" <email@example.com> wrote:
>In a for next loop I want to insert at a certain position (below it is
>position 15) in a cell chr(10) (...