Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    99

    Re: Open and space two folders

    I have copied and added your code to a new standard module, changed the necessary backslashes, and updated the file paths to reflect what I need them to be. When I run the macro, it opens the correct...
  2. Replies
    4
    Views
    99

    Open and space two folders

    I would like to open two windows folders on the screen and have them appear side by side on the monitor. I have the code below to open both folders and that part works fine. I just need to know how...
  3. Replies
    3
    Views
    78

    Re: formula to count text inside a cell

    Perfect!! Thanks for the quick response. Works exactly as I need it to.
  4. Replies
    3
    Views
    78

    formula to count text inside a cell

    I have a spreadsheet that has three cells merged vertically. In this cell I enter six different letter codes to help me track performance instances. These are "A+", "A-", "m+", "m-", "+", and "-"....
  5. Replies
    3
    Views
    127

    Re: Check workbook name for specific word

    Awesome!! Thanks Fluff for the quick response. Very simple code fix. Works great!
  6. Replies
    3
    Views
    127

    Check workbook name for specific word

    I am looking for a way to see if the workbook name contains the word "Template". If so, I want the macro to prompt the user to save the file. I have the code listed below, but it does not seem to...
  7. Replies
    3
    Views
    128

    Re: transfer data with resize

    Thank for the awesome detailed response. The adjustments to the macro work great. I appreciate the feedback and the education. You are the best!!
  8. Replies
    3
    Views
    128

    transfer data with resize

    I am trying to move data from my active worksheet to a destination worksheet without using specific named ranges. When I run the code below, I get the following error: "Run-Time error '438': Object...
  9. Replies
    3
    Views
    108

    Re: get file name root folder

    Beautiful!! Thanks. I figured it would be something fairly simple.
  10. Replies
    3
    Views
    108

    get file name root folder

    I have the get folder location function listed below. I would like the dialogue box that opens to start into a specific root directory. This will allow the user to start at this location which they...
  11. Replies
    4
    Views
    231

    Re: For-Next loop Syntax error

    Here is what I need my code to do.

    1) I have a sheet (Intro) with a column (B2:B30) that has the number of copies needed for each sheet in the workbook (search text is listed in Column O).
    2) All...
  12. Replies
    4
    Views
    231

    For-Next loop Syntax error

    I am trying to write a for next loop and I am getting a "Compile Error: Syntax error" when I enter the phrase "Continue For".

    I want the code to check the AX2 cell on each sheet, if the cell...
  13. Replies
    4
    Views
    226

    Re: worksheet copy

    My desire to use a do loop function was that I could start at the middle of the work book and work to the end. Can I do the same thing with a for...each approach and iterate through the remaining...
  14. Replies
    4
    Views
    226

    Re: worksheet copy

    Thanks Tony, that little "Set" addition worked great. Now for another problem, when I run the macro the second DO loop I have runs through all the worksheets updating the cell AM4 as desired. When it...
  15. Replies
    4
    Views
    226

    worksheet copy

    I have a list of all the worksheets in my workbook on tab 1. I want the user to put a number next to the sheet in column B and have the macro copy the selected worksheet one less times than the...
  16. Replies
    2
    Views
    86

    Run Time error.

    I have the following code for a save as macro.




    Sub SAVE_EVAL()

    Application.ScreenUpdating = False

    Dim FSName As String
  17. Replies
    6
    Views
    300

    Re: auto highlight row

    Since I am fairly new to VBA, can you provide the code needed to update the conditional formatting for the document. I like the idea of having that in my ThisWorkbook code window and called from the...
  18. Replies
    6
    Views
    300

    auto highlight row

    I have been using a process outlined on the tech republic website (see link below) to highlight the selected row from column A to column L. In general the process works great, however I have found a...
  19. Replies
    5
    Views
    239

    Re: Shut off a specific macro

    Thanks for helping me see the not so obvious.
  20. Replies
    5
    Views
    239

    Re: Shut off a specific macro

    Here is the private sub




    Private Sub Worksheet_SelectionChange(ByVal Target As Range)


    Range("L8:L2008").ClearContents
  21. Replies
    5
    Views
    239

    Shut off a specific macro

    I have a Private Sub macro that runs upon worksheet change. I have another macro that is trying to enter a new row of data to the bottom of the list. Whenever this macro runs, the on change macro...
  22. Replies
    3
    Views
    147

    Re: On worksheet change macro control

    I made that change, but it doesn't affect the issue I am facing. The code below is the one that will fail, along with others. It fails on the line below:

    ActiveSheet.Range("$A$7:$K" &...
  23. Replies
    3
    Views
    147

    On worksheet change macro control

    I have a macro (Macro A listed below) on a worksheet page VBA code window. Macro A will work in conjunction with conditional formatting and a defined Name which is a cell to capture the row I am on,...
  24. Replies
    0
    Views
    127

    Transfer from report

    I have a department listing page which has the department names in Columns ACE...etc. This is the sheet I want to transfer into. Call it Sheet A. I also have a spreadsheet that is generated from a...
  25. Replies
    3
    Views
    206

    Re: Assemble list of sheet names

    Great Thanks!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4