false

  1. C

    VLOOKUP Macro Workbook Reference Variable

    Good morning, I am trying to create a macro that opens reference files and later will pull data out to compare in primary workbook (wkb). wkb3 is going to be the previous days file in each case, and opening the file works without issue. I am running into an issue referencing the Workbook...
  2. V

    Save file as folder name/sheets as file name

    Hi I would like to change this code to save the file as the folders name instead of "Total Results.xlsm" Also I'm trying to name the worksheets the same as the files that its importing instead of "Data" & i +1 Thanks a lot to anyone that can help Sub ImportCSVData() Dim wb As Workbook Dim...
  3. V

    Declare a variable to a cell

    Hi everyone! I've been stuck with declaring a variable to a cell value and need some help. Situation: I have a code that filters a table and transfers the filtered data to another sheet. The filter could be the date value but I can't set it properly. The result is always Error 1004. I've tried...
  4. A

    Copy rows with data to another workbook

    Hi I have the below code to copy rows with data from one workbook to another ignoring the first two rows as these are header rows however it is only copying column 1. Where am I going wrong? Sub Export_data() Dim ws As Worksheet, wb As Worksheet Set ws = Sheets("Triage") Set wb =...
  5. S

    VBA help to copy rows when key words are selected

    Hello, I use the below code to transfer rows from the "LOG" Tab to the "RTN HISTORY" tab when "SCRAP", or "RELEASED" in Col Z is selected from the drop down. My question is how would I have it transfer back to the LOG tab if "HOLD" is selected from the dropdown? Thanks for all...
  6. H

    IF statement Help

    =IF(C7="Rosemont University",E7*$P$28,IF(C7="Clayborn University",E7*$P$28,IF(C7="Branch College",E7*$P$28,IF(C7="Eastern Wisconsin University",E7*$P$28)))) My issue is that I can seem to remove False from my cells. Any help is appreciated
  7. G

    Insert Found Column

    Set fnd = Range("8:8").Find("WBS", , , xlWhole, , , False, , False) If Not fnd Is Nothing Then Intersect(Range("8:5000"), fnd.EntireColumn).Copy Range("B8").PasteSpecial xlPasteValues Intersect(Range("8:5000"), fnd.EntireColumn).ClearContents End If Hello The code above is working...
  8. G

    Excel-Word Interop, Add Watermark Issue

    I have a workbook that will convert multiple word documents at once into PDF format. I am combining two macros I found on the web to try and get them to open a word doc, place a watermark on the doc, and then export it as a PDF. It will do this once for each file in a folder that I specify in...
  9. A

    run time error 9

    Hi I have the below code to copy data from one workbook to another but keep getting a subscript out of range error on the line... Set wb = Workbooks("2019_-_Couriersheet_-_copy.xlsx").Worksheets("Triage2") Both workbooks are open and I've checked the file name is correct etc. What could the...
  10. E

    Check status of current filter mode

    I need to understand the syntax and code to determine what filters are currently applied to a spreadsheet so that I can return the filters to the sheet at the end of my macro. I currently have a macro I created to copy and insert a row of data identical to the row your cursor is on. The first...
  11. A

    if formula not working and showing false result

    <tbody> <tbody> 10000 </tbody> =IF(A8>0<=100000,25,IF(A8>100000<=500000,50,IF(A8>500000<=50000000,100))) result is showing false . why </tbody>
  12. W

    Struggling with nested functions

    Can someone please help me to write the following formula? Conditions: if A1 and B2 are blank and A2 and B1 are NOT blank If True: = A2 If False: (leave cell blank)
  13. S

    VBA to search for values and delete rows

    This macro works great for me for one name but I would like to modify it to allow for additional names to be added. Sub Cdelete() With ActiveSheet .AutoFilterMode = False With Range("d13", Range("d" & Rows.Count).End(x1Up)) .AutoFilter 1, "*NAME*" On...
  14. V

    Macro to convert 1 row into multiple rows except for zeroes

    Hi guys here is the 2 macros I have for this issue. The first one transforms one row from into 4 different rows and the next one removes the rows that have a zero. This way seems to crude and I was wondering how would I improve it. I'm thinking arrays and ranges probably? Thanks a lot Sub...
  15. U

    Userform display control

    Using the following code to show/hide Labels and OptionButtons on a Userform UserForm1.Label5.Visible = False UserForm1.OptionButton2.Visible = False They still show, any ideas ?
  16. B

    Run-Time error '1004' Method 'SaveAs' of object'_Wokkbook' failed

    Hello, I'm trying to save a newly created file in csv format. I am copying results from one open file, and pasting in a new workbook, and then trying to save the new workbook as a csv file. My code is below. See the "Save File as CSV" section below. Thanks! Sub Monthly_Device_Volume_Map()...
  17. gheyman

    VBA code paste as text not formula problem

    I have code that was running great for more than a year. Now its adding in the formula as text so its not doing the calculation any longer "=IFERROR((INDEX(Detail!C[-2],MATCH(CMOP!RC[-1],Detail!C[-2],0))),""DELETE"")" Any help is appreciated Sub StripDown() ' ' Macro1 Macro ' If...
  18. M

    Unprotect copied protected sheets and paste a range as value

    Hi All I have this code below, I'm trying to figure out how i can copy protected sheets and unprotect together with copying a specific range and pasting it as value only. Hoping for a quick response. Thank you! ? Sub CopySheets() Application.ScreenUpdating = False Dim MyFolder As...
  19. A

    Limit (Not total Denial) Pasting within a Worksheet

    Hello, I would like to deny pasting into certain columns (F:G) without disrupting that ability elsewhere. I've searched for this and have come close to a solution, but they haven't been quite right. I used the following but it restricts pasting for the entire sheet Private Sub...
  20. A

    Run-time error '-2147024809(80070057)' - The PivotTable field name is not valid

    Trying to updated pivot table filters of different sheets of different workbook, but the getting error message "Run-time error '-2147024809(80070057)' - The PivotTable field name is not valid... " Need help to resolve the issue and get the code running. Private Function UPivot(PName As...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top