Round Function Error
Tue, 23 Sep 2008 05:29:01 -0700
Please see the following Macro
Sub Data1()
a = 1.845
a = Round(a, 2)
End Sub
i am getting "a" value as 1.84 instead of 1.85.
What should i do? ...
|
MESSAGE "CANNOT EMPTY CLIPBOARD" - COPY/PASTE FUNCTION NOT WORKIN
Tue, 23 Sep 2008 05:07:01 -0700
My clipboard is empty. But I continue to get an error message "cannot empty
clipboard" when I try to copy. As such the copy/paste function is not
working. Excel 2003. How do I correct? ...
|
Excel Add-In
Mon, 22 Sep 2008 07:13:01 -0700
I have Hyperion/Essbase on my computer in Excel. I keep getting the Essbase
error message "You do not have sufficient access to perform a lock on this
database". I have uninstalled and re-installed Hyperion/Essbase multiple
times on my computer and I can not get the error message to stop. It has
gotten so ...
|
Problem with a template in Excel 2007
Fri, 19 Sep 2008 16:13:01 -0700
Hi everyone and thanks in advance for any help you can offer. It seems I can
always find someone on here with the answer I need.
I am using XP Pro and Office 2007.
I'm not sure how to describe my problem, but here goes:
I have built a template and saved it as an .xlts file. It appears in the "My
Templat ...
|
Problem with Excel 2007
Fri, 19 Sep 2008 16:12:00 -0700
Hi everyone and thanks in advance for any help you can offer. It seems I can
always find someone on here with the answer I need.
I am using XP Pro and Office 2007.
I'm not sure how to describe my problem, but here goes:
I have built a template and saved it as an .xlts file. It appears in the "My
Templat ...
|
Image is not dispalyed in excel 2007 Red X appears
Fri, 19 Sep 2008 05:12:00 -0700
Using Activereports , Excel 2007 workbook is generated with the image.In
first page image appears in the consecutive pages the below error message
appears.
The image cannot be displayed. Your computer may not have enough memory to
open the image, or the image may have been corrupted. Restart your compute ...
|
Data Validation problem -large spreadsheets- Excel 07 (Student -Tr
Thu, 18 Sep 2008 19:16:01 -0700
I have a large spreadsheet with 6 tabs each with up to 100 columns and 1000
rows. I am able to create and use a list style data validation, but when I
save the file and reopen it, the validation is gone. I can create a new
(blank) spreadsheet that uses data validation and it saves and opens
properly.
I ...
|
|
|
multiple if statements in one formula
Thu, 18 Sep 2008 11:43:01 -0700
I have 2 if statements that I am trying to combine into one formula. What is
the correct sequence for these to work? ...
|
re-edit chart title causes errors
Wed, 17 Sep 2008 12:26:04 -0700
I am building several charts on a worksheet and pulling data from other
sheets in the workbook. After having one or two charts in a worksheet I have
to edit chart titles to reflect the data because it changes. When I attempt
to edit the chart title sometimes it works perfectly, but most of the time it
displa ...
|
How to build a macro to sort data on every worksheet in EXcel?
Wed, 17 Sep 2008 08:55:01 -0700
I was trying to build a macro to sort data on every worksheet within Excel
2007. However, after recording the macro, the macro seems to only refer to
the original worksheet. The macro does not work in other worksheet.
Here is the sequence I used:
1. Start recording new macro.
2. CTRL+Pagedonw to go to ...
|
