vba & excel 2019

  1. E

    Force Excel 2019 VBA to import multiple txt file to existing sheet & not seperate wk.book / wk.sheets

    A little bit of a strange one for me as I have experienced this issue before . I have a sub which is a file picker. This allows a user to navigate to a windows folder and select 1 or many text files and then import them into Excel. Excel is *supposed* to import all selected text files in to an...
  2. E

    VBA to remove Apostrophes works but also gives Run-time error 13. Unable to work out why?

    Windows 10 Excel 2019 In Column K, the cells are populated by a formula. In some cells the formula will have nothing to return ("") and Excel inserts a (') Apostrophe which I need to remove but only for the cells where the formula has returned nothing. I have the code below that selects...
  3. C

    Allow copied worksheet to have duplicates with Date & (2),(3) etc Please Help!

    Sub CopySheet() Worksheets("Sheet3").Copy after:=Worksheets(3) ActiveSheet.Name = Format(ActiveSheet.Range("D28").Value, ("DD-MM-YY")) End Sub
  4. M

    Convert cash/bank statement into journal entries

    I have a cash statement as in above picture for a specific cash account, which includes the following: Transaction date Amount in or out Charged account number and name Description Document reference Transaction currency and exchange rate I need to convert this statement into journal entries...
  5. K

    vba code to select file and unzip files in a different folder with different name

    HI All, Am looking for a vba code to select a file from a folder and unzip the file in a different folder with different file name. Can you please assist me with the code. Thanks in advance.
  6. B

    VBA - Layout and sorting with conditions

    Hi Team, I'm facing the current scenario, I will start by placing the sheet that i'm working in and then bring up what has to be done: ABCDEFGHIJKL12UUIDWhatsover1Whatsover2Whatsover3Whatsover4Whatsover5Whatsover6Whatsover7Whatsover8Whatsover9Adjust and...
  7. M

    Select a series of Tables within multiple others, a specific range of Rows within said tables, and then transpose said Rows into a column.

    Greetings everyone, I have a question (as seen in the title), which is kind of a pickle. (Using Microsoft excel 2019, on Windows platform) Basically, I have an Excel document filled with Tables. 50+ or something. The logic behind what I want to do is easy enough; I want to select specific...
  8. S

    Adding Sequence numbers based on Cell value in ColumnB through VBA

    Hi Friends, I am trying to add sequence/following numbers in ColumnA based on cell value in ColumnB. I been doing it manually, but its taking countless hours to go through thousands of rows. Thought that I can get some little help here. Attached the spreadsheet to understand more. ( Hightail...
  9. S

    Excel VBA copy row content based on cell value from ColumnE

    Hi friends, I been trying to find some vba automation to fill my needs today. Attached are sample test file along with outputfile format. I did used vba for inserting number of rows required at some point between rows. Please take a look sample output file with highlighted rows and compare them...
  10. R

    VBA Word Paragraph Text Effects Properties

    Hi, I am trying to pull (from an Excel 2019 workbook) the text effects (outline, shadow, reflection, glow) applied to different paragraphs (or 1st word in each paragraph) of a Word 2019 document. When I run the code, although the Word document has text effects applied to each paragraph I get a...
  11. S

    How to run VBA Macro on Workbook instead of worksheet

    Hi Friends, I have 100s of Excel workbooks with single sheet in each. Every time I have to open each workbook and run the macro to do the job. I am looking to modify and run the macro on list of workbooks in folder one by one. So Macro will run through all excel files in folder one by one and...
  12. S

    How to Construct Auto Boolean Strings using VBA

    Hi Friends, I tried looking mrexcel posts and google sources for query to find VBA answer. Here what I am looking for is: Sheet1 ColumnA has data of boolean strings like attached in the document. The row numbers varies every time whenever I change the data. Boolean example has shown in image...
  13. S

    Find list of words from sheet2 in sheet1 before a comma and extract text vba

    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details. Need a formula to find list of words before a (,) comma from sheet2A:A in Sheet1A:A(there is no data range like A1:a10) and extract text before the...
  14. R

    Excel VBA Multiple Notifications

    Hello, This may or may not be a simple porcess as I am very new to coding for macros. I have 3 processes I want to implement into my excel. First, I want to change my current highlighting process for columns I & J. They are highlighted green for all non-blank-cells. I wish to highlight them...

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