Can not insert new graph in powerpoint. get messaage to first close opening

box or cancel editing mode in excel.

Could you please help?

Thank you

box or cancel editing mode in excel.

Could you please help?

Thank you

- How do you attach a macro in excel 2003?
- How do you open SPSS files in excel?
- How do you use VBA functions in Excel. Help!!!!
- In Excell - How do you get infomation typed in one cell to appear.
- How do you prevent duplicate entries in an excel spreadsheet?
- In Excell - How do you get infomation typed in one cell to appear.
- How do you use access macro from excel
- How do you automatically update content between excel documents
- How do I download office assistant in excell
- How do you remove file bloat in Excel?
- How do I insert a clock in excel worksheet?
- How do I get traffic lights in excel that change colour
- How do I get the columns in Excel to go back to letter sequence
- How do I arrange worksheets alphabetically in Excel?
- How do I create a formula in Excel that will countif or sumif bef.
- How do i enter negative times in Excel & how can they be 'fiddled.
- How do I fix column widths in Excel Pivot Tables?
- How do I hide a worksheet in Excel and use a password to un-hide .
- How do i create Lorenz curve in Excel????
- How do you create custom buttons in office 2007?
- How do i report a bug in excel
- How do I close a link in Excel 2000?
- How do I get the columns in Excel to go back to letter sequence
- How do I change a column in Excel from upper case to lower case?

Is this code right? Its supposed to return the ColorIndex value of a cell, and how do you insert it into a standard module in an Excel workbook.

Function ColorIndexOfCell(Rng As Range, _

Optional OfText As Boolean, _

Optional DefaultAsIndex As Boolean = True) As Integer

Dim C As Long

If OfText = True Then

C = Rng.Font.ColorIndex

Else

C = Rng.Interior.ColorIndex

End If

If (C < 0) And (DefaultAsIndex = True) Then

If OfText = True Then

C = GetBlack(Rng.Worksheet.Parent)

Else

C = GetWhite(Rng.Worksheet.Parent)

End If

End If

ColorIndexOfCell = C

End Function

Function GetWhite(WB As Workbook) As Long

Dim Ndx As Long

For Ndx = 1 To 56

If WB.Colors(Ndx) = &HFFFFFF Then

GetWhite = Ndx

Exit Function

End If

Next Ndx

GetWhite = 0

End Function

Function GetBlack(WB As Workbook) As Long

Dim Ndx As Long

For Ndx = 1 To 56

If WB.Colors(Ndx) = 0& Then

GetBlack = Ndx

Exit Function

End If

Next Ndx

GetBlack = 0

End Function

...

> In Excel -

> How do you get information typed in one cell to appear in another

> pre-choosen cell location.

You need to use the formula bar. Select the cell that you want to copy the

data into (say, A1). Then click on the " = " button on the formula bar.

(This means that the selected cell (A1) will show the result of a formula).

Then select the source cell (say, B1) and click enter (or click on the tick)

button. Whatever info is entered into B1 will also be displayed in A1.

Point to note: if you cut and paste cell B1 to any other cell, then the

info in cell A1 will be linked to the new address of cell B1. Ordinarily,

this is a good thing. However, it might not be what you want.

Regards

Kev

How do you get information typed in one cell to appear in another

pre-choosen cell location.

how do you use access macro from excel? see line marked ***

I want to run this VBA code which is in Access

Have the following code:

Code:

Sub Import_Staff_alloc_xl() '--------------------------------------------------------------------------- 'Open Access '--------------------------------------------------------------------------- Dim AccessApp As Object Dim strMsg As String 'Set the path on YOUR PC for Db strDatabasePath = "c:Test.mdb" 'Create an instance of the Access application object. Set AccessApp = CreateObject("Access.Application") 'Open the ct Db with Access. On Error Resume Next With AccessApp Application.DisplayAlerts = False .OpenCurrentDatabase strDatabasePath .DoCmd.MakeNewTable ' End With AccessApp.Visible = True End Sub

the paper clip. Thank you.

the file size remains the same. How do you shrink it?

result returned in a variance cell?

Then clear the R1C1 checkbox

--

Gary's Student

"Lostinexcel" wrote:

> How do I get the columns in Excel to go back to letter sequence. It was

> displaying a letter sequence on the columns. What happened.

after a specific date? Whenever I put the actual date in the formula it

works, but when I reference to the cell the date is in it returns 0.

allow SUM functions etc... to work correctly? When I try to enter a negative

time in time format [h]:mm an error message pops up saying put a ' in front

.. This does allow the negative time to be entered but when this cell is

incorporated in a SUM funtion it is ignored. There is probably a simple

solutionto this, but as an excel novice it has me stuck!

How do I fix column widths in Excel Pivot Tables so that width does not

change with each refresh?

change with each refresh?

possible that there isnt such option on this version? Or its there under

another name? I could find it under Chart wizard in another version. Please

help, i would need it urgently!

Thanks,

Judit

displaying a letter sequence on the columns. What happened.

No luck finding an answer? You could always try Google.