Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    50

    Re: Calling a Sub within the Main Macro

    Thanks!
  2. Replies
    4
    Views
    50

    Calling a Sub within the Main Macro

    I am having issues with this string of code:

    Sub Format_Workbook_Pt2()

    Sub ConvertTextToNumber()
    Sheets("All_Data").Select
    Range("C:C").Select
    ...
  3. VBA Code Conditional Formatting in Project

    Does anyone have a string of code to highlight late tasks in MS Project?
  4. Replies
    0
    Views
    98

    VBA Code Question

    Hey all!

    I was wondering if anyone had a VBA code string to embed an outlook calendar into powerpoint.

    Thanks!
  5. Replies
    5
    Views
    179

    Re: Dates Stored as Text

    Got it! Thanks
  6. Replies
    5
    Views
    179

    Re: Dates Stored as Text

    I've tried text to columns using the date function, datevalue, changing to number then tried using text to columns.
  7. Replies
    5
    Views
    179

    Dates Stored as Text

    I am having an issue where my dates are stored as text but still look like they are in date format. I have tried everything to fix this including text to columns. Are there any other ways to convert...
  8. Replies
    3
    Views
    174

    Re: IFERROR or Error On in VBA

    There are errors due to 0 being in the denominator. I would need to set the value of the formula (I/H) to 0

    Thanks!
  9. Replies
    3
    Views
    174

    IFERROR or Error On in VBA

    I am fairly new to coding in VBA and was wondering how to add an error formula to the following string of code:

    For I = a To lastRow
    If Range("I" & I).Value / Range("H" & I).Value > 1 Then
    ...
  10. Replies
    2
    Views
    130

    Re: Formula to Calculate FY

    I work with multiple clients who have varying fiscal year ends. I help prepare financial statements to where I would need to calculate the fiscal year to be sure the data is falling into the year in...
  11. Replies
    2
    Views
    130

    Formula to Calculate FY

    I have played around with a few formulas, but have been fairly unsuccessful to get a formula to calculate fiscal year on multiple dates. Does anyone here have one that has worked well?


    Thanks.
  12. Replies
    1
    Views
    1,501

    Create Dynamic Range for a vLookup

    Hey there. I was wondering what the formula would be to create a dynamic range for a vlookup. The columns will remain constant, however the number of accounts will vary depending on the client.
    ...
  13. InputBox Error if left blank or cancel is selected

    Hey all! I have been trying to figure out the code to give an error message when the user leaves it blank or hits cancel with no luck. Thanks for the help!!
  14. Replies
    3
    Views
    224

    Re: Compile Error: Variable Not Defined

    Thanks! That worked, I was trying to use a codename. Thanks again!
  15. Replies
    3
    Views
    224

    Compile Error: Variable Not Defined

    Hey there! I am trying to get some code to work and had a friend help me try to clean it up. It worked when he ran through it, but now I am getting a Compile Error. I have made the line where the...
  16. Replies
    1
    Views
    133

    Autofill with VBA

    Hey all. I am using the following code to attempt to autofill a formula to the last row as defined. I am receiving a 400 error and was wondering if anyone has a solution. Thanks

    Dim lastRow As...
  17. Replies
    4
    Views
    132

    Re: Inserting Columns

    Great, this works. Thanks!
  18. Replies
    4
    Views
    132

    Inserting Columns

    I have the following code to insert columns, but for some reason it won't insert them. It doesn't give an error, the macro just stops and doesn't insert:

    Sub Worksheet_S10()


    'Activate...
  19. Thread: Error 400?

    by BrittKnee
    Replies
    4
    Views
    112

    Re: Error 400?

    Great! This worked, thanks!!
  20. Thread: Error 400?

    by BrittKnee
    Replies
    4
    Views
    112

    Error 400?

    I am writing a simple string of code and continue to get an Error that reads "400." I found a thread that addressed this, but thought maybe it had something to do with the code.

    Sub...
Results 1 to 20 of 20