Copy and paste several charts problemHello,
I use Excel 2002 and Windows 2000 professional.
Here is a code example in which I am trying to just copy two chart
from a template sheet, paste them into another sheet, delete the chart
and then loop 150 times. This causes the problem "Excel cannot paste th
data" after a while.
Why? Any ideas about how to avoid this error message and solve thi
problem?
In my originally code after copying the charts into the new sheet
adjusts the charts and copies them into word, before they are deleted
I have not managed to create the charts completely from scratch by VB
code, this is w...
Microsoft word problem!Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
When I open Microsoft word it brings up a passed document that I wrote and saved. I then threw it in the trash and it is stil coming up. It is on the screen everytime I open up word. This is also a paper that I wrote in test rive and now I have the actual program. What should I do?
Thanks
Every time you create a new Word document, this document is based on a
template called Normal.dotm. You have somehow managed to put this text into
your Normal template, which is why you can see this strange behaviour. To
fix the proble...
Repeating cell-contentsA1 contains "Smith"
A53 contains "Jones"
A459 contains "Smith"
A1072 contains "Peterson"
A23405 contains "Smith"
A45234 contains "Samantha"
What formula can I use to put:
"Smith" in B1 thru B52
blanks in B53 thru B458
"Smith" in B459 thru B1071
blanks in A1072 thru B23404
"Smith" in A23405 thru B45233
blanks in A45234 thru A65536
Thanks,
Gary
Hi Gary
try the following:
In B1 enter
=A1
in B2 enter
=IF(A2="",B1,IF(B1="",A2,""))
and ...
Problem with Attachments #4Hello, can anyone help?
Outlook Express removes the attachments from about 80% of my incoming
emails.
How can I prevent this happening?
Any suggestions would be much appreciated.
Rob
Wrong Newsgroup; this group is for Microsoft Office Outlook, not Outlook
Express. There are specific newsgroups for OE and you find a much higher
degree of expertise on OE problems in these groups. Having said that, see
if these help:
To disable the blocking of Any attachments, see:
Cannot Open E-Mail Attachments in Outlook Express 6 After You Install SP1
http://support.microsoft.com/?kbid=329570
To adju...
excel press enter to make active on 1st colum in new rowlets say I have 10 colums in a worksheet, when in colum 10 of row, i want to
automatically go to colum 1 of row 2
Enter the following in Worksheet code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("J:J"), Target) Is Nothing Then
Exit Sub
End If
Cells(Target.Row + 1, 1).Select
End Sub
After an entry is made in column 10, we move back to column 1 the next row
down.
REMEMBER: Worksheet code.
--
Gary''s Student
gsnu200711
"Greg" wrote:
> lets say I have 10 colums in a worksheet, when in colum 10 of row, i want to
> auto...
Date,Time ProblemHI!!
We take the difference of two Date/Time Fields having Custom format and
Values like this
Start Date End Date Cycle
Time
2/24/03 16:30 3/25/03 10:11 689:41:41
m/d/yy h:mm m/d/yy h:mm [h]:mm:ss
Now I want this Time to be taken as absolute Number expressing it as
Hours/Minutes, so that I can take such values for further analysis.
But as such it is not possible because Excel always show �Cycle time�
value (689:41:41) as �28/01/1900 17:41:41�, and does not yield to any
arithmetic operations.
H...
Text to RowsHi, I am newbie in excel Macros. I have a macro that works well if used on a
cell. BUT if I want to run it on every cell within a Range, I get an error -
"Invalid, Next control Variable reference". Please help. see below
Sub NewOne()
Dim x As Integer
Dim y As Integer
' Hardcoded range A1 to C2
NumRows = Range("A1", "A2").Rows.Count
NumCols = Range("A1", "C1").Cols.Count
Range("A1").Select
For x = 1 To NumRows Step 1
For y = 1 To NumCols Step 1
'Text to multiple ro...
For those with problems logging in online and downloading from some institutions
There is a significant change today 19 July at the servers
which provide online sign in with LiveID/Passport and get the
statements for those institutions that don't provide their own OFX
servers.
See the top and the "Scheduled Events" section of
http://articles.moneycentral.msn.com/common/networkstatus.aspx
for information. That site will be updated as things progress. That
will include specific instructions of what the user will need to do.
In the mean time, log in offline.
Cal - have you seen more details or how/why/what they are improving? Do you
think it is somethin...
Hide multiple rows when particular cell is zeroHi All,
Can anyone tell me how I can hide multiple rows when a particular cell
is zero?
It has to go automaticly, so no buttons...
When D37=0, hide rows 37-48
When D49=0, hide rows 49-58
When D59=0, hide rows 59-68
When D69=0, hide rows 69-78
When D79=0, hide rows 79-88
etcetera.
How can help me with this macro??
Thanks in advanced.
Best regards,
BL
Hi,
What should happen if e.g. D38 = 0?
Maybe this applied to the desired sheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim a, rng As Range
Set rng = Range("D37:D1000")
For Each a In rng
...
OWA connection problem #2I have a SBS2k3 R2 server with one nic behind a hardware firewall. Can
anyone tell me which ports to open/forward on the firewall to allow Outlook
Web Access?
Any and all help appreciated.
--
-------------------------------------------------------------------------------
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may not be disclosed to any other
parties without the prior permission o...
Problems with Page MarginsHello all - this is my first posting here so I hope I provide enoug
information with regards to my question. I have been using Excel fo
about 10 years.
Background:
I have used Excel (Office XP) to create pages that will be put into
journal. I used Excel because, as many of you know, it is easier t
format text for use in forms (I.E. journal entries with check boxes
etc.)
There are roughly 10 different pages that are on individual worksheet
within the workbook. I have formatted the page size by using margi
settings to print out on (1) page. (I have not used forced pag
breaks)
Settings: TOP...
Printing a Repeated Section Messege like "Continued"Setting the repeated section property in a report (Access 2007) to Yes,
writes the section Heading on the next page when the detail section is not
complete at the page break. I would like the bottom of the first page to
print "Continued on Next Page" and/or the top of the second page to say
"Continued from ...)" so the report reader knows the details are part of the
previous section on the previous page, and not in an entriely new section of
the report. Can this be done dynamically in a report, since some pages
naturally break when a section ends and other pag...
Problems with HolidaysHi there. I am using Outlook 2000 for Windows XP - Home Edition. I have
followed the instructions to add holidays to my calendar - in this case,
Canadian and Christian holidays. Once I complete the process, there are no
holidays there. I have been reading on this group about "OutHol.exe". What is
this file? Do I need it? If so, how can I get it?
When you reply, can you please reply by email to llimbo72@yahoo.com? For
some reason my hotmail account randomly decides not to deliver mail from some
people, so I can't rely on it.
Limbo.
If you have Outlook 2000 or an earlier ...
copying and pasting only non-hidden rowsWould anybody know how to copy an entire worksheet and
paste values only to a new worksheet and include only
visible rows (do not include hidden rows)
Thanks,
Jason
Jason, you can do it with a macro, here is one way
Sub Macro1()
ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisible).Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** r...
Repeating rows dont repeat fully when columns also repeatI am repeating rows 1 through 4 and columns A through D. At least
that is what I'm trying to do. On page two, the columns repeat but
then the rows do not (beyond columns A through D). Is there a way to
make it so that they both repeat?
In re-reading the above, I'm not sure I'm making myself clear.
Assume that XX's represent the repeating rows and ZZ's represent the
repeating columns. This is what I'd like to see:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
ZZZZZZZZZZZ YYYYYYYYYYYYYYYYYYYYYY
ZZZZZ...
PlamI synchronise my Palm with MS Oulook 2002 (Windows XP) several times a day. For my calendar, I have set the sync on 'synchronise files'. It used to work fine until about a month ago (when I have installed the last Windows SP?). Now, instead of synchronizing, it simply adds up all the events. I end up having 50 events on the same day and same time (because I have done 50 synhronisations) !
Any solution or advice...?Thanks.
...
random numbers, how can you utilize it without repeating themHow can you use random numbers without repeating them on a worksheet? The way
it is set up now is, example: =RANDBETWEEN(1,8)
I would like to be able to use the random between but I don't want the
numbers to repeat themselves within the worksheet. Any suggestions or Ideas?
http://www.mcgimpsey.com/excel/udfs/randint.html
--
Regards,
Peo Sjoblom
(No private emails please)
"RS" <RS@discussions.microsoft.com> wrote in message
news:75427E72-3EAA-4105-A65B-53F0F1213414@microsoft.com...
> How can you use random numbers without repeating them on a worksheet? The
>...
Problem in displaying the chart
Hi all,
Good evening. I am facing one problem at creating chart. This
is my coding.
Charts.Add
ActiveChart.ChartType = xlBarClustered
ActiveChart.SetSourceData Source:=Sheets("Data").Range("A5:E6"),
PlotBy:= _
xlRows
* ActiveChart.Location Where:=xlLocationAsObject, Name:="Cost"*
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = _
"5 Time Predictability of Design and Construction"
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).Has...
Sub-Report ProblemI have a sub-report that prints "exactly" as it should, but then repeats
many, many times.
The stand alone sub-report prints two pages.
The sub-report in the main report prints 4226 pages (duplicates of two
pages, 2113 times).
The reports are NOT linked.
The sub-report is located in the Detail section of the main report.
I select to print this sub-report from a form, and then make the appropriate
controls visible/not visible depending on the type of report I want. It
works great, just too many pages on the sub-report. All other main reports
(as selected from the Form, work fi...
AppCrach Problem
This program Modio worked fine untill 2 days ago. It keeps shutting down
before I get to use it. These are the deatails: *
problem signature:
*problem event name: appcrash
application name: modio.exe
application version: 1.0.0.0
application timestamp: 4a5a1505
fault module name: stackhash_27f2
fault module version: 0.0.0.0
fault module timestamp: 00000000
exception code: c0000005
exception offset: 0001136c
os version: 6.0.6001.2.1.0.768.3
locale id: 1033
additional information 1: 27f2
additional information 2: 325055436168101a578479ab72a66d1a
additional information 3: 21e2
...
Macro for changing number of rowsHello -
So I'm a little less experienced than I thought.
Below is my table.
Item Rate 1 Rate 2
A 0.60% 0.30%
B 0.50% 0.40%
C 0.50% 0.70%
E 0.30% 0.30%
F 0.20% 0.50%
Below is my Macro:
Sub Ordering_Macro()
'
' Ordering_Macro Macro
'
'
ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.Add
Key:=Range _
("C2:C6"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
ActiveWorkbook.Worksheets("Sheet1").AutoFilt...
Create rows from a lookupHi all,
I have 2 worksheets containing data that I need to combine, by creating rows
WS1 has product data in the range of:
Product_ID Name price Options_Ref
1 Product 1 10.00 18
2 Product 2 15.00 25
3 Product 3 5.00 18
4 Product 4 20.00 7
WS2 has the option list data such as:
Options_Ref Option_Description
7 Red
7 Blue
18 12"
18 14"
18 16"
25 ...
Junk E-mail problemsI have just set up a new system with Office 2003 and have
also installed Windows XP SP2. I copied my .pst file and
safe sender list from my old system to the new one only
to find that the Junk E-mail Options, even though it is
set to Safe Lists Only, does not work. All e-mail goes
directly into my inbox rather than into the Junk E-mail
folder. Can anyone explain how this happened and how I
can fix it.
Thank you
...
Problem with attachmentsSuddenly when one of my co-workers sends me a Word doc. my Outlook 2000
blocks it, saying it blocked the potential unsafe .lnk file? What is a .lik
file and what is happening for it to show up this way?
Thx for any info.
Gary
*.LNK is a shortcut to a file. Double check with your co-worker to make
sure they mean to send you a shortcut. (Shortcuts can be construed as a
program and might be a worm/virus.) They may say "oops" and send you the
actual word document and not a shortcut to something.
"algae" <boycefamilynospam@shaw.ca> wrote in message
news:vl70d.35...
repeating cells in footer in excelI need prepare a form with many lines. In this form I need to provide a
footer (with a group of cells) for approvement. Even I can select cells to
repeat in every page header there is no such a feature for footers.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http:...