Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    61

    Export to word 1row & range

    Hi

    I have a problem with below code. As you see it takes only 1 rows but I would like to add range to this code as it is below. It doesn't work but I hope to find support here.

    I paste only...
  2. Replies
    1
    Views
    128

    multiple conditioning macro

    Hi

    I need your help. I have a problem with multiple conditioning in VBA


    If LCase(Trim(.Cells(lRow, "P"))) = "0" & LCase(Trim(.Cells(lRow, "N"))) = "Name" & LCase(Trim(.Cells(lRow, "O"))) =...
  3. Replies
    13
    Views
    360

    Re: Macro Conditional ececution

    okay, so you totally don't understand me. Anyway thanks for you help.

    Above solution is unuseful for me. I still need to find a way how to conditionally execute macro assigned to button.
    ...
  4. Replies
    13
    Views
    360

    Re: Macro Conditional ececution

    Button Name: 'button1'
    Sheet1

    Conditions that have to be met:

    If Not Intersect(Target, Range("A1")) Is Nothing Then Select Case Target.Value
    Case 2
    Call FirstMacro
    Case 4...
  5. Replies
    13
    Views
    360

    Re: Macro Conditional ececution

    I never answer without check sth before. Thank you for your reply but as I said this is not exactly what I need.

    I would like to assign conditionally executing macro to the button.

    Right now...
  6. Replies
    13
    Views
    360

    Re: Macro Conditional ececution

    yes, sorry. It is because I don't know how to change it/do it....

    I would like to assign a above (similar) code to the button and after click on button above (similar) code should be run.

    I...
  7. Replies
    2
    Views
    172

    Re: Insert image - dialog box (window)

    Perfect. Thank you !
  8. Replies
    13
    Views
    360

    Re: Macro Conditional ececution

    Hi everyone

    I would like to use (run) below code only when I click on button. How can I do it ?

    Thanks


    Private Sub Worksheet_Change(ByVal Target As Range)If Not Intersect(Target,...
  9. Replies
    2
    Views
    172

    Insert image - dialog box (window)

    Hi

    I need to create a button with macro which open Insert image - dialog box (window)

    Any idea how to do it ?

    thanks
  10. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    Hey, Last question ;) I have small problem.

    Currently my Macro exports data from two worksheets: Cells 1-16(extCRM), and Range(Excel).

    Everything works well but I would also like to export...
  11. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    ok, works. Many thanks Worf
  12. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    Seperately it works fine...but when I add your code then there is above error with bookmarks...

    Any solution ?

    Thanks
  13. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    Sorry Worf, my mistake. Now it works but there is another issue. Error 424 object required.

    I checked bookmarks, template file, crm file - all is fine


    Private Function PathExists(pname) As...
  14. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    Many thanks Worf for your time and help

    I combined my code with your but there is some error:(red) run-time error 9 out of range. I checked cell, name and everything is correct so I don't know why...
  15. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    Thank you so much Worf ;)

    I hope that you will have a time to help with second part as well ;)
  16. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    Hey guys, pls help me a little bit with above issue
  17. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    No idea ?:(
  18. Replies
    12
    Views
    476

    Re: Save/create Folder&File with Name from Cell

    I will be so grateful if someone find a time to solve this problem, help me to do this.

    Thanks
  19. Replies
    13
    Views
    360

    Re: Macro Conditional ececution

    I'm not sure whether it is what I need. Any alternatives ?

    Thx
  20. Replies
    13
    Views
    360

    Macro Conditional execution

    Hi everyone

    Question. How to run a macro based on some conditions.

    Example:

    If A1 = X then (when I click run macro - button) use Macro 1
    If A1 = Y then use Macro 2
  21. Replies
    12
    Views
    476

    Save/create Folder&File with Name from Cell

    Hi everyone.

    I need you help.

    I have a problem with macro. Everything here works (export to word etc) but there are some things which require to be corrected. Below what I need.

    1. Create a...
  22. Replies
    6
    Views
    433

    Re: Range -> Bookmark

    Bold lines -> this is what I need

    Thanks
  23. Replies
    6
    Views
    433

    Re: Range -> Bookmark

    I take Data from 2 Excel files.
    1. CRM - external Excel file: Sheet1 (sheet)
    2. Current opened Excel file: CRM2 (sheet)

    I would like to take a Data Range from 2nd sheet - Sheet1 in Current...
  24. Replies
    6
    Views
    433

    Re: Range -> Bookmark

    No ideas ? :(
  25. Replies
    6
    Views
    433

    Range -> Bookmark

    Hi there

    I have a small problem. Could you tell me / advice how to assign a Range to Bookmark from Sheet1 in below case ?

    thanks!


    Sub SomeSub()Dim r As Integer
    Dim wdApp As...
Results 1 to 25 of 49
Page 1 of 2 1 2