Search:

Type: Posts; User: ChuckDrago; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Excel 2010 Macros not running in Excel 2016

    JKPieterse and Fluff - Immensely grateful. Removing the MISSING did it. Fluff, we moved 64 bit to 64 bit. so I presume that shouldn't matter... or does it? Your observation on UserName was...
  2. Excel 2010 Macros not running in Excel 2016

    Hi everyone,

    I hope this is only a setup condition that someone identifies, but the transition from Windows 7 and Excel 2010 to Windows 10 and Excel 2016 has caused a lot of agita.
    For starters,...
  3. Selecting, coloring and defining a range

    Hi everyone,

    For an app under development, I need the user to:
    1) Select a range of rows within a single column (say, A5:A15)
    2) Color the background of the selected range.
    3) Click on a button...
  4. Replies
    6
    Views
    245

    Re: Counting with multiple criteria

    Thanks BH... I adopted AhoyNC's solution but your point is well taken, in case of a future use of SUMPRODUCT. I have used that powerful function before but never with multiple criteria. Your...
  5. Replies
    6
    Views
    245

    Re: Counting with multiple criteria

    [QUOTE=AhoyNC;5291667]Maybe something like this. Copy formula down and across as needed.

    AhoyNC... That is sweeeeet!. Rather than looking for a formula to calculate each condition, multi-copying...
  6. Replies
    6
    Views
    245

    Counting with multiple criteria

    Hi everyone,
    I have been asked to provide charts for returned merchandise by return code. I initially imagined building a table where the merchandise ID was in column "A" and column "B" will have...
  7. Re: Little Nudge needed to get me home free

    Latest and greatest: Whoever needs to do what I tried, check this https://www.devhut.net/2016/02/01/vba-save-a-word-document-as-a-pdf/ Their code, while a bit extensive, worked flawlessly.
    Thank...
  8. Re: Little Nudge needed to get me home free

    No cigar... It reports Error 5 (Invalid procedure, call or argument)
  9. Re: Little Nudge needed to get me home free

    No good, sorry.
  10. Little Nudge needed to get me home free

    Hi everyone,

    I am trying to get a Word document to open (so that it updates its date) and then save it to a designated folder as a pdf. I tried to adapt a great macro I got in this forum but to...
  11. Replies
    3
    Views
    163

    Re: Exporting a worksheet range as pdf

    It works a treat!
    Immense gratitude, Mr Fluff.
    Not the first time I got great advise from you and every time spot on. Thanks again,
    Chuck
  12. Replies
    3
    Views
    163

    Exporting a worksheet range as pdf

    Hi everyone,

    Got a tough one today (well, for me at least).

    A workbook application collects data from the company server and populates a worksheet form (not UDF, just the sheet designed as a...
  13. Replies
    5
    Views
    109

    Re: Resume Next not Resuming

    Works like a dream (used to be a nightmare!). Thanks a lot, Fluff.
    Chuck
  14. Replies
    5
    Views
    109

    Re: Resume Next not Resuming

    Almost there, Fluff...and thanks for the assist. Now, what I need is to ACTIVATE the cell where CurID was found, so that I can extract data using ActiveCell.Offset(0,x). I wrote MsgBox...
  15. Replies
    5
    Views
    109

    Resume Next not Resuming

    Hi all,
    I have a macro that loops through a list of items, locates them on another sheet via a FIND method and collects some data pertaining to the found item. It works well, except that it stops...
  16. Replies
    0
    Views
    113

    Closing workbooks from other workbook

    Hi everyone,

    We have an hourly reservation calendar where users reserve slots of time for their use of the corresponding conference room. Playing with fire, I always considered that two users...
  17. Re: Detecting the address of an active range

    Thank you oodles! This code provides also the column, which saves me the extra step of testing for it.
    The intended app is a Reservation calendar for the various Conference Rooms we have around. ...
  18. Detecting the address of an active range

    Hi everyone,

    I am trying to build an app where the users can select a group of cells (row wise). If they click on a specific cell, I can get the row address by using ActiveCell.Row. However,...
  19. Replies
    0
    Views
    126

    Addressing text boxes in Userforms

    Hello everyone,

    Need assistance on syntax to write a common value to different text boxes.

    My Userform has 25 text boxes, renamed "TB1", "TB2,...,"TB25". Each box has an extra box on the side...
  20. Replies
    0
    Views
    849

    Printing Zebra labels from Excel

    This is a tough one, rather special situation.
    We use serial number labels printed by Zebra Thermal Transfer Printers. The labels were created using the Zebra Pro Label software. After a label is...
  21. Replies
    5
    Views
    159

    Re: Erasing a picture by its number

    Aha! That is exactly what I was looking for. Thank you shg.
    Chuck
  22. Replies
    5
    Views
    159

    Re: Erasing a picture by its number

    shg, not clear as to how to use that. An example: assume I have inserted a Stop sign as picture 1 and picture 2 is a Go sign, to serve as my master copies. The application will define whether a...
  23. Replies
    5
    Views
    159

    Erasing a picture by its number

    Hi All,
    Is there a way to get the picture number of a picture previously inserted in a worksheet so that I can erase it by selecting "Picture" & x, the latter being the suffix number of said pix?...
  24. Replies
    0
    Views
    132

    Scan fails to start on designated cell

    Hi everyone,

    I have a worksheet that accepts scanned data from bar coded cards. The records are parts to be ordered and they include their responsible buyer.
    I have provided additional...
  25. Replies
    2
    Views
    163

    Re: Passing a value instead of a formula

    ranman256 Appreciate your help but... I adopted a portion of your code and modified mine to continue copying the way it was, adding the special paste bit at the end (looking like below). Then...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4