vba coding excel macro

  1. An Quala

    VBA Code for deleting complete rows if it has specific text

    Hi, so I need to delete the complete row if specific criteria is met, the criteria is as follows, In a sheet named called "Data" If column B contains either of "John", "David", "Susan", "Macro", few of them, or all of them, then delete those specific rows leaving the others (Note: If any of...
  2. B

    Copying certain information from a text file using VBA code

    Is there a way to create a code to 1st read a specific .txt file based off of the .txt file's name listed in a certain cell in Excel and then enter that certain information from the .txt file below that .txt's file name in the very next row below the file name's cell? If so, could it search &...
  3. Glitch5618

    Compile Error: Argument not optional

    Using excel 2007. I've been banging my head against the wall on this one for awhile now. I'm rather new to VBA so forgive me if this is a simple matter. Basically I have a program that filters data, and based on the filters applied you click a button aptly named Get Data. This program has...
  4. H

    Hiding/Unhiding multiple rows automatically based on cell condition

    Hi, I'm looking for a way to hide and unhide the rows based on the condition in D & E. Lets say I want to list all documents that have TR00001 in D or E, I will type TR00001 into a cell(C3). Doing this all other rows in the defined range shall be hidden. If I type in TR00001 into cell C3, all...
  5. S

    How do I copy an active row from excel into a Word Document already with a specified table template in it?

    Hi All, I am new to writing this Macro stuff but have been successful with a couple tricky ones so far, so any help would be much appreciated. I have the task of putting property availability schedules together for clients. This task is quite laborious as I have to copy the information from...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top