Search:

Type: Posts; User: Siddharth Rout

Page 1 of 13 1 2 3 4

Search: Search took 0.85 seconds.

  1. Re: Iterate attributes of PageSetup property of worksheet with Excel VBA

    See the solution by Jaafar Tribak. This solution doesn't need "TLBINF32.DLL".
    ...
  2. Replies
    2
    Views
    1,279

    Re: .FindNext error

    I know I am late for the party but this may help any future visitor so I will go ahead and post a solution.

    The .Find is happening on wsWFD.Columns("E") so .FindNext should happen on that range.
    ...
  3. Re: I don't understand where the error is.

    Dan has already given you the answer as to why you are getting that error. It is important that you qualify your objects completely.

    As a personal preference, I always declare objects and work...
  4. Replies
    3
    Views
    1,357

    Re: Resize Image Control at runtime

    Ok you gave me an idea. It does solve the problem and for that due credit to you (rated your answer)

    I set the Autosize = False and then set it to true in UserForm_Initialize()



    Private Sub...
  5. Replies
    3
    Views
    1,357

    Re: Resize Image Control at runtime

    Autosize = True will not help. It is already set to Autosize = True at design time. I then resize the control and make it very small. I want to resize it at runtime.
  6. Replies
    3
    Views
    1,357

    Resize Image Control at runtime

    I am stuck in a very peculiar situation. Seems like no one has ever asked this question before or maybe I am not able to search for it.

    There is a Userform in Excel. It has an Image Control. It's...
  7. Replies
    14
    Views
    3,398

    MsOf365 Re: Strange Run-time error '6' Overflow

    Also use "Long" instead of "Integer" when working with Excel rows. I guess you are getting the error because of that.

    Change



    Dim MaxNum As Integer
    Dim ChooseColumn As Integer
  8. Replies
    14
    Views
    3,398

    MsOf365 Re: Strange Run-time error '6' Overflow

    Also use "Long" instead of "Integer" when working with Excel rows. I guess you are getting the error because of that.

    Change



    Dim MaxNum As Integer
    Dim ChooseColumn As Integer
  9. Replies
    14
    Views
    3,398

    MsOf365 Re: Strange Run-time error '6' Overflow

    A small suggestion.

    Avoid the use of .Select/.Activate/Selection/Activecell/Activesheet/Activeworkbook

    Two Main reasons why .Select/.Activate/Selection/Activecell/Activesheet/Activeworkbook...
  10. Replies
    4
    Views
    4,772

    Re: Excel Macro VB Mismatch error

    Change


    Dim username As LongPtr

    to


    Dim username As String
  11. Re: Excel VBA : Help me to join string and variable using VBA

    When you are writing a formula you cannot leave it to the user. There are lot of things that you need to consider. For example

    1. Have they entered the correct syntax?
    2. Have they entered the...
  12. Re: Excel VBA : Help me to join string and variable using VBA

    What is the value of `TextBox3`?
  13. Replies
    24
    Views
    4,537

    MsOf07 Re: vba-excel allow-paste-special-only

    Unfortunately, the code that you are using is not meant for such complex operation. You will have to re-do the code from the scratch keeping all your requirements in mind. Mind you, it will not be a...
  14. Replies
    24
    Views
    4,537

    MsOf07 Re: vba-excel allow-paste-special-only

    Hi Stephen

    Got your PM. Slightly busy with other projects and hence was not able to reply on time. Anyways, I see lot of posts above. So if you want me to effectively and quickly help you then can...
  15. Re: need a code to remove special character

    You do not need to write so many lines if you want to remove them. Here is a shorter way to do it :)



    Sub replChar()
    Dim ws As Worksheet
    Dim rng As Range
    Dim SpecialCharacters As...
  16. Re: Using TRIM with Evaluate Isn't Working

    Here is one piece of code which you will rarely see being used :)

    You can TRIM a range in one line i.e without looping.



    Sub Sample()
    [C1:C1000] = [INDEX(TRIM(C1:C1000),)]
    ...
  17. Re: I need help - Macro to print page to pdf and send to a person on a list

    The code by Ken is good. Go ahead with that :)
  18. Replies
    9
    Views
    2,272

    Re: [RESOLVED] closing excel problem

    I have not tested this but try this. This will not leave an instance.



    Sub main()
    Dim oXLApp As Object, oXLWB As Object, oXLSht As Object
    Dim QuitIt As Boolean

    '~~>...
  19. Replies
    9
    Views
    2,272

    Re: closing excel problem

    If your query is not resolved then you do not need to mark it as resolved :)
  20. Re: Need help writing some VB code

    You seemed to have missed what I mentioned in post #25?

    Is this what you are trying? I fixed the Caps issue as well.



    Option Explicit

    Sub Sample()
    Dim MyArray() As String
  21. Re: Need help writing some VB code

    >>>Is there any way of removing the Input box so it can be added only if needed? As in putting the code in a comment?

    Yes put a single quote before it :)



    'This is a commented code

    ...
  22. Re: Unpin files from taskbar with VB.net code

    I hope TG has cleared the confusion regarding merging of the threads :)

    Did you try the code that I gave? You can easily remove the entries using that code.
  23. Replies
    11
    Views
    1,784

    Re: INSERT image in subitems of lisvtview

    I answered a similar question 8 years ago :D

    Is this what you want?

    http://www.vbforums.com/showthread.php?562763-How-to-add-checkboxes-in-subitem-of-listview&p=3478144&viewfull=1#post3478144
  24. Re: Need help writing some VB code

    Sorry was having Dinner. Replace



    '~~> Highlight duplicates
    For Each itm In Col
    Selection.Find.ClearFormatting
    Selection.HomeKey wdStory, wdMove
    ...
  25. Re: Need help writing some VB code

    You mean just highlight the text or the number?
  26. Re: Need help writing some VB code

    Great. If your query is solved then feel free to mark the thread "Resolved". If you do not know how then see the link in my signature :)
  27. Re: Need help writing some VB code

    Simply remove the Inputbox and change the line



    If Left(MyArray(i + 1), 4) = Ret & "-" Or Left(MyArray(i + 1), 5) = Ret & "-" Then


    to
  28. Re: Need help writing some VB code

    I thought you wanted to choose?
  29. Re: Need help writing some VB code

    Is this what you are trying? :)



    Option Explicit

    Sub Sample()
    Dim MyArray() As String
    Dim n As Long, i As Long
    Dim Col As New Collection
  30. Re: Need help writing some VB code

    Ah I see.. So you want to type "HCI or ERL or MSRS" and it should highlight the duplicate for those?
  31. Re: Need help writing some VB code

    Like this?

    HCI-10001
    HCI-15002
    HCI-15153
    HCI-10001
    ERL-14122
    ERL-15002
    ERL-10001
    MSRS-51112
  32. Re: I need help - Macro to print page to pdf and send to a person on a list

    Well you need the desktop version (MS Outlook - Paid Version). Else do what Pete Suggested. Use CDO :)
  33. MsOf365 Re: Macro / VB Coding help needed please

    Great!

    If your query is solved then feel free to mark the thread resolved :) If you do not know how then see the link in my signature.
  34. MsOf365 Re: Macro / VB Coding help needed please

    That is because there is some space in the worksheet name. Go to the worksheet and retype the name of worksheet in it's tab. Remember to remove the spaces.
  35. Re: I need help - Macro to print page to pdf and send to a person on a list

    Welcome to vbforum :wave:

    >I have been able to do a bit of code to convert an excel sheet to a pdf and send it via gmail but I dont know what the next steps are

    Why not use Outlook? It is much...
  36. MsOf365 Re: Macro / VB Coding help needed please

    Is this what you are trying?



    Sub Sample()
    Dim wb As Workbook
    Dim wsI As Worksheet
    Dim NewFileName As String

    Set wb = ThisWorkbook
  37. Re: Need help writing some VB code

    I guess you are replicating my stackoverflow post? :D That logic will not work here.

    Ok quick question. What should happen to these numbers. I mean what output are you expecting?

    Before
    ...
  38. MsOf365 Re: Macro / VB Coding help needed please

    So this is what I have understood.

    1. You are running this code from the workbook "Blastbag Work Instruction"
    2. There are 2 sheets. INPUT" and "DATA"
    3. The filename is in cell D8 of INPUT...
  39. Re: Need your help to work this faster and doesnt freeze when running the code.

    I only give code in a platter if I am paid for it LMAO (Just Joking)

    I can but I want you to try it yourself. Else how will you learn mate?
  40. MsOf365 Re: Macro / VB Coding help needed please

    Ok scratch that. Let's start from the beginning.

    We will rebuild from the start and we will try and have only one macro in lieu of 5 if possible :)

    Explain what exactly are you trying to do....
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width