Search:

Type: Posts; User: Jim Cone; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    8
    Views
    1,824

    This article in PC magazine, about "CloudMark"...

    This article in PC magazine, about "CloudMark" (free) sounds pretty good.
    I have not tried it.
    http://www.pcmag.com/article2/0,2817,2385203,00.asp

    '---
    Jim Cone
    Portland, Oregon USA ....
  2. Replies
    1
    Views
    1,731

    ActiveChart.SeriesCollection(1).Points(1).Border.L...

    ActiveChart.SeriesCollection(1).Points(1).Border.LineStyle = xlContinuous
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (Calculate Payments XL add-in: amount,...
  3. Replies
    5
    Views
    1,611

    See attachment... Data sorted by name Data...

    See attachment...
    Data sorted by name
    Data subtotaled by volume
    Groups with zero total - delete
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (free and...
  4. Replies
    5
    Views
    1,611

    Just sort the data by column C (volumes), then...

    Just sort the data by column C (volumes), then delete.
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (XL Companion add-in: compares, matches, counts, lists,...
  5. Replies
    4
    Views
    4,133

    Chip Pearson has code to create a folder/file...

    Chip Pearson has code to create a folder/file listing here...
    http://www.cpearson.com/excel/FolderTree.aspx
    You could create two separate lists and copy/paste both of them on a new sheet.

    There...
  6. Replies
    4
    Views
    1,744

    Could be that the sheet name(s) doesn't exist or...

    Could be that the sheet name(s) doesn't exist or the Pub_ workbook is not open.
    Also, I recommend using "Color" not "ColorIndex" to define colors in xl2007 and later: .Tab.Color

    '---
    Jim...
  7. Replies
    4
    Views
    5,869

    You might to also try this flavor... ...

    You might to also try this flavor...

    Range("C5").Activate
    Do While Not IsEmpty(ActiveCell)
    If ActiveCell.Value = "Blank" Then
    ActiveCell.EntireRow.Delete
    Else
    ...
  8. Replies
    1
    Views
    1,215

    See your other identical post in Spreadsheets.

    See your other identical post in Spreadsheets.
  9. Replies
    4
    Views
    5,869

    When deleting items from a collection, the...

    When deleting items from a collection, the general rule is to delete from the end back to the beginning. This modified version of your existing code, however does delete without problems...
    '---...
  10. Replies
    8
    Views
    6,855

    Maybe too many styles? This free add-in (Formats...

    Maybe too many styles? This free add-in (Formats & Styles) can list or remove them...
    http://excelusergroup.org/media/p/4861.aspx
    (about 1100 downloads)
    '---
    Jim Cone
    Portland, Oregon USA ...
  11. Replies
    2
    Views
    4,290

    Big Round Button | Excel Options (button) |...

    Big Round Button | Excel Options (button) | Popular (on left side top) | Include this many sheets: (spin button)
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware ...
  12. Replies
    1
    Views
    679

    I deleted the blank rows on your attached file...

    I deleted the blank rows on your attached file and ended up with 40 rows with data.
    I don't know how that compares to what you expected.

    On your original data, I would just sort the data - blank...
  13. Replies
    0
    Views
    445

    Adobe advises of Flash flaw...

    http://www.scmagazineus.com/adobe-advises-of-flash-flaw-exploited-via-excel-docs/article/198312/
    "Adobe advises of Flash flaw exploited via Excel docs"

    According to the the article a patch is due...
  14. Private Sub ComboBox1_DropButtonClick() '---...

    Private Sub ComboBox1_DropButtonClick()

    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (Lottery Numbers.xls - in the free folder)
  15. Replies
    4
    Views
    1,637

    RowStart and FinalRow are evaluated once by Excel...

    RowStart and FinalRow are evaluated once by Excel at the start of the loop.
    The RowStart and FinalRow values are not reevaluated during the loop.
    You will get uncertain results by trying the...
  16. Replies
    3
    Views
    2,981

    I just had a similar experience with xl2007 and...

    I just had a similar experience with xl2007 and windowsXP.
    What fixed the problem was deleting the .xlb file that contains the menubar/toolbars (or ribbon) configuration.
    The file is automatically...
  17. Replies
    11
    Views
    2,547

    Kweaver: To get possible winning numbers for the...

    Kweaver:
    To get possible winning numbers for the MegaMillions game or six other national/regional lotteries, my "Lottery Numbers" Excel workbook free download is here......
  18. Replies
    8
    Views
    22,137

    For what it is worth, the Microsoft xlsclean.exe...

    For what it is worth, the Microsoft xlsclean.exe download that was recommended only does a partial clean. It removes all content from the unused rows at the bottom of a sheet, but does not clear the...
  19. Replies
    3
    Views
    603

    Something simple... Enter a zero for no renewal,...

    Something simple...
    Enter a zero for no renewal, enter 1 for renewal.
    Sort ascending by forecast percent.
    Count the number of zeros in the bottom half vs. the top half.

    Or almost a simple......
  20. Replies
    1
    Views
    574

    You could use a dynamic range that self...

    You could use a dynamic range that self adjusts...
    Example... http://www.contextures.com/xlNames01.html#Dynamic
    ''---
    Jim Cone
    Portland, Oregon USA
    30 + ways to sort in excel
  21. Maybe... Function GetSpecialFolders(ByRef...

    Maybe...

    Function GetSpecialFolders(ByRef vFolder As Variant) As String
    Dim WSHShell As Object
    Set WSHShell = CreateObject("WScript.Shell")
    GetSpecialFolders =...
  22. Replies
    4
    Views
    3,095

    Re Office 2000: be careful what you wish for....

    Re Office 2000: be careful what you wish for. <g>

    Excel prints selections on separate pages.
    Have your co-worker copy and paste the two selections on a separate sheet and print that sheet.
    '--...
  23. Replies
    10
    Views
    1,003

    Sub GetAddedUp() Dim LastRow As Long LastRow...

    Sub GetAddedUp()
    Dim LastRow As Long
    LastRow = Application.WorksheetFunction.Max _
    (Cells(Rows.Count, 9).End(xlUp).Row, _
    Cells(Rows.Count, 10).End(xlUp).Row)

    ...
  24. Replies
    8
    Views
    4,345

    I can't duplicate your problem with Firefox...

    I can't duplicate your problem with Firefox 3.5.11 on WindowsXP SP3.
    I just tried this ebay item: Some software
    Firefox gave me a separate window when I clicked "enlarge".
    '--
    Jim Cone
    Portland...
  25. Replies
    3
    Views
    2,006

    You can paste the data into Word and use Format |...

    You can paste the data into Word and use Format | Columns
    or
    try to find a third party utility/add-in to arrange the columns in Excel.
    '--
    Jim Cone
    Portland Oregon USA
    Special Print (Side by...
Results 1 to 25 of 238
Page 1 of 10 1 2 3 4