Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    7
    Views
    116

    Re: Image in Footer via VBA

    .
    Haven't tested here but ... I am thinking change the name of the image on each page to a unique name relating to that
    specific worksheet.

    Combing your macros so MACRO1 is included within the...
  2. Replies
    3
    Views
    157

    Re: Creating a Dynamic Floor plan

    .
    Glad you found a solution.

    Willing to share ?
  3. Thread: Pricing tool

    by Logit
    Replies
    1
    Views
    56

    Re: Pricing tool

    .
    One method using Dependent Dropdown lists :

    https://chandoo.org/wp/dynamic-cascading-dropdowns-that-reset/
  4. Thread: Help with VBA

    by Logit
    Replies
    1
    Views
    96

    Re: Help with VBA

    .


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)


    ActiveSheet.Unprotect "gary" '<<--- this line unprotects the sheet.


    If Target.Cells.Count > 1 Then Exit Sub
  5. Re: Macro to produce e-mails based on values in cell

    Glad to help.
  6. Re: Sudden explosion in size of sheet in workbook

    .
    Hmmm .... the macro works well here without errors.

    Perhaps you have a corrupted workbook at this time.
  7. Re: Sudden explosion in size of sheet in workbook

    .
    Make a COPY of your workbook.


    On the copy only, apply this macro :



    Sub LipoSuction()
    'JBeaucaire (8/3/2009)
  8. Re: Auto Print after scanning in 7 digit barcode

    The line in Post #4 should be sufficient.

    Side comment: Quoting previous posts in your reply is not required unless it is absolutely necessary to explain your answer.
    All the extra data consume...
  9. Replies
    3
    Views
    130

    Re: Building a better mousetrap.

    .
    I think the first challenge is to determine if the touch screen will work with any calculator.
  10. Replies
    3
    Views
    130

    Re: Building a better mousetrap.

    .
    Try the download on this URL for a complete calculator. See if it works on a touchscreen :

    https://analysistabs.com/vba-code/excel-projects/calculator-userform/
  11. Re: Auto Print after scanning in 7 digit barcode

    Is Sheet 2 the active sheet when you run the macro ?

    You can only use Intersect() if the range is on the same worksheet.


    If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
  12. Replies
    5
    Views
    170

    Re: Macro for Removing Dates 11 Days in Future

    .
    Hmm ... would you be ok posting your workbook to a cloud site like DropBox.com or similar ?

    Provide the download link here.
  13. Re: Macro to produce e-mails based on values in cell

    .
    Re your updated request. Here are two new macros to replace the existing:



    Sub CreateSheets()


    Dim Cell As Range
    Dim RngBeg As Range
  14. Replies
    4
    Views
    147

    Re: Required merging with macro button!

    .
    Post and AFTER image so we know what you are seeking.

    How do you want the cells to be / look after the merge ?
  15. Replies
    4
    Views
    147

    Re: Required merging with macro button!

    .
    Is this what you are seeking ?





    Sub delete_empty_cells_shift_left()
    Range("A1:I5").Select
    Selection.SpecialCells(xlCellTypeBlanks).Select
  16. Re: Auto Print after scanning in 7 digit barcode

    .
    I am presuming your macro errors out on the line noted below ?




    If Intersect(Target, Sheets("Sheet2").Range("A1")) Is Nothing Then
    Exit Sub
    Else '<-- possibly here ?...
  17. Replies
    3
    Views
    157

    Re: Creating a Dynamic Floor plan

    .
    Have you found a solution to your request ?
  18. Replies
    5
    Views
    170

    Re: Macro for Removing Dates 11 Days in Future

    .
    Why are you filtering the rows ?

    Try without filtering.
  19. Re: Macro to produce e-mails based on values in cell

    .
    Glad to help.
  20. Re: Macro to produce e-mails based on values in cell

    .
    This code is different from the first submission. For no particular reason I used two Regular Modules.
    You can do the same or place all macros in a single Module.

    Module #1 :



    Option...
  21. Replies
    5
    Views
    170

    Re: Macro for Removing Dates 11 Days in Future

    .


    Option Explicit


    'Keep any row with a value in column D
    'Remove any rows where column D is blank and is 11 days out in column G
    'Remove any rows where date is 11 days out in column G
  22. Re: Display 2 rows with multiple columns as 1 row with multiple columns

    .
    Where did the number 17 come from ?
  23. Re: Macro to produce e-mails based on values in cell

    .
    Let me review your request .... give me some time.
  24. Re: Macro to produce e-mails based on values in cell

    .
    Paste in Regular Module :



    Option Explicit


    Sub srtMe()
    Dim LastRow As Long
  25. Re: Macro to produce e-mails based on values in cell

    .
    Please post a representative sample of your existing workbook with simulated data.

    This forum does not allow for attachments ... you'll need to use a Cloud website like : DropBox.com , etc
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4