Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    1
    Views
    368

    Re: Combining multiple Worksheet Change Events

    Hi,

    I am not sure I am fully understanding the problem but does this help?



    Private Sub Worksheet_Change(ByVal Target As Range)
    On Error GoTo ExitPoint
    Application.EnableEvents =...
  2. Re: VBA to Add or Subtract Hours from the Local Date and Time

    Hi,

    If your cells contain times then you should be able to add fractions of a day. So, to add 14 hours you would need to add 14/24 to the time.


    Regards,
  3. Replies
    5
    Views
    429

    Re: Read email from Outlook

    Thanks Kenneth.


    Regards,
  4. Replies
    5
    Views
    429

    Re: Read email from Outlook

    Hi,

    Is there anything in here that might get you started? https://www.mrexcel.com/forum/showthread.php


    Regards,
  5. Replies
    1
    Views
    192

    Re: Pivot Table Sorting

    Hi,

    You just need to pick a number in a column and apply a sort.

    Here are some more details:...
  6. Re: scanning in UPC's ... How to get them entered as a string (text)

    No problem. Great to know that it worked.


    Regards,
  7. Re: scanning in UPC's ... How to get them entered as a string (text)

    Hi,

    Try adding a single quote to the start:


    Cells(ii, 7).Value = "'" & upc

    (That's a single quote surrounded by a pair of double quotes.)
  8. Replies
    1
    Views
    160

    Re: Macro Chart Creation help Please!

    Hi and welcome to the MrExcel Message Board.

    First question: Will it work without that line?

    If it does need to be then then try replacing it with:


    ActiveChart.Activate

    but I can't...
  9. Replies
    3
    Views
    247

    Re: Hard to read the "Properties" Window

    Other alternatives for Windows would be to change the Windows Settings. From Settings pick System and then Display.

    You have the option to scale up the text size for the whole screen or to reduce...
  10. Re: Auto Sort Column Descending - Data In Column Is Taken From Another Sheet Using =IF Function

    Hi,

    I think this works:


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 4 Or Target.Column = 10 Then
    With ThisWorkbook.Worksheets("Sheet3")
    ...
  11. Replies
    3
    Views
    247

    Re: Hard to read the "Properties" Window

    Hi and welcome to the MrExcel Message Board.

    I don't think that Excel has that feature but if you are using Windows 10 it has a built-in magnifier. See here:...
  12. Re: Ability To Navigate Back To Previous Cell Selected

    No problem.

    If all software just worked and was entirely intuitive then lots of people would be without a job. ;)


    Regards,
  13. Re: SAP RFC not working on Windows 10 / Excel 2016

    No problem. It does look as if their are issues so I hope you can fix it.


    Regards,
  14. Replies
    9
    Views
    1,859

    Re: Renaming Userform within VBA

    Sorry, I have been out of circlation for a couple of days.

    Did you use CustomUI to create your custom icon? If you do that then the icon will be stored with the Add In so when you de-delect the...
  15. Re: Personal.XLSB Access Problems - Excel 2016/Office 365

    Great news! I am pleased you got it working.

    I am sorry I could not iron out the issues. I knew it would not be entirely straightforward but I am writing this from a hospital bed and do not have...
  16. Re: Personal.XLSB Access Problems - Excel 2016/Office 365

    Hi,

    Sorry I can't try this out right now but you should be able to convert your Personal.xlsb into an Add In.

    If you can still open the Personal then you should be able to save it as a .xlam...
  17. Re: establishing a range in vba based on cell contents

    Does this work for you?


    Sub Test()
    With ThisWorkbook.Worksheets("Sheet1").UsedRange
    .AutoFilter Field:=8, Criteria1:="<>"
    .SpecialCells(xlCellTypeVisible).Select
    ...
  18. Re: SAP RFC not working on Windows 10 / Excel 2016

    Is this any help? https://archive.sap.com/discussions/thread/3505080

    ( I Googled: sap rfc office 10 )


    Regards,
  19. Re: establishing a range in vba based on cell contents

    It does depend on what you mean by "space".

    If the cells are empty then it will work. If they contain an actual space character then it won't.

    If you can clarify I will take another look.

    ...
  20. Re: establishing a range in vba based on cell contents

    Hi,

    This code will select just the rows with numbers in - assuming that the data is sorted with the empty cells at the bottom.


    Sub Test()
    With ThisWorkbook.Worksheets("Sheet1")
    ...
  21. Re: SAP RFC not working on Windows 10 / Excel 2016

    Hi,

    Not sure but I could make a guess.

    Assuming the only thing that has changed is the OS and Office versions, I would guess that the SAP Functions libraries have not been installed. If that...
  22. Replies
    9
    Views
    1,859

    Re: Renaming Userform within VBA

    I woke up this morning asking myself if the link I gave you was to an Add In or a conventional macro-enabled workbook. Unfortunately, it is the latter so you will need an extra step in the...
  23. Replies
    9
    Views
    1,859

    Re: Renaming Userform within VBA

    I have had a quick look at your code and it seems to save OK as an Add In. It is quite easy. You write your macros in the usual way then you make sure that you save the workbook as an "Excel Add In"....
  24. Thread: Email Sheet

    by RickXL
    Replies
    5
    Views
    317

    Re: Email Sheet

    Thanks for letting me know.

    One thing I did notice is that you might want to get rid of this line:


    .Windows(1).Visible = False

    It makes it look as if the received workbook is empty.
  25. Replies
    9
    Views
    1,859

    Re: Renaming Userform within VBA

    Hi,

    I am not quite sure what you are trying to achieve but you might be better off with an Add-In. Would that be an option?
    Basically, you keep all the master code and forms in the Add-In then...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4