macro

  1. H

    Converting a number into particular format

    Hello, What is the best way to convert following format into e.164 in excel i.e. i would like to convert numbers in the format 123 456-0001 to \+11234560001. Column A Column B 123 456-0001 \+11234560001 123 456-0005 \+11234560005 123 456-1000 \+11234561000
  2. B

    VBA - Amend Conditional Formatting

    Hello, I have an excel 2013 template that is sent to me every month from another department - there are some manual adjustments that need done to the workbook before I send it out and I have written a simple macro which does this for me. The only thing I cannot get to change is some...
  3. D

    VBA Macro Button to only show columns 30 60 90 days out

    Hi, I need to create a macro that will select a group of columns H:FS, and will hide columns within that range not meeting the following criteria. The criteria would either be 30, 60, or 90 days from the current date. Im new to VBA code and macros but id imagine I would need 3 different subs...
  4. C

    VBA / Macro Copy, Paste, Loop

    Hi All A little help please for a complete VBA / Macro novice. I am trying to automate the coping of data from one sheet to another whereby the macro I have takes all the data in the first data row (row 2) of sheet 1 ("Standard report - Items"), copies this to a new sheet, then selectively...
  5. M

    How to create output for a specific line in Macro?

    I have a macro code and I want to make output for some lines. Is there a way? consider the following, I want to see what is the "ActiveCell.Offset(off, 0)"? Sub Opter() 'Application.ScreenUpdating = False 'Call Module1.Iterations Do While IsEmpty(ActiveCell.Offset(donum, 0)) = False If mini = 1...
  6. S

    Delete two lines above bookmark - keep bookmark VBA

    Hello, I hope you all are well. I want to write a macro to delete two lines above a bookmark in a word document. So far so good, but the bookmark itself should not be deleted. I have come up with the following code: Sub DeletetwoLinesAboveBookmark1() Dim r As Word.Range Set r =...
  7. G

    Count consecutive negative numbers

    I am looking for a formula or vba, whichever is easier, where if the value in the row is negative, it will count until the next 0 or positive number, for the whole column. An example is below. I searched and couldn't find the exact thing I was looking for. Any help will be greatly appreciated...
  8. A

    Excel freezes while running macro

    Hello all I have a module which gets data from a web API and then copies that data to the excel sheet, while this macro is running, all the other excel sheets freezes for a couple of seconds. Any help to optimize this code would be greatly appreciated. I just want this macro to run in the...
  9. G

    Macro for Convert DOT to Comma and Comma to DOT

    Dear Friends, Need help from you, i am trying to convert Dot to comma and when i covert the value decimal points are not appearing example attached and given below as well. When the third decimal point if is zero then i am not getting the third decimal after i convert example below. Input ...
  10. M

    VBA macro help reflection workspace

    Hi, When I running below code works fine ExcelApp.activesheet.range("b2").copy But below code shows error as (object doest support this property or method) ExcelApp.activesheet.range("j2").paste Please help
  11. S

    Delete content of Word chapters but keep the title - VBA

    Hello, I hope all of you are healthy. I have a word document that contains several chapters including assessments concerning various topics. Since I have to update the document each week, I have tried to write a macro that deletes the contents of all chapters, but keeps the title of the...
  12. E

    VBA - Help with LOOPs - copying range to another worksheet's next available row

    I am looking for some assistance making the code below run for all selected cells in rows 27-67. The code below works for the first row; it copies contents from the selected cells to the next available row on a different worksheet.How can I make it loop through rows 27-67, copying cells from...
  13. O

    A problem about "information transfer between sheets".

    Hi everyone! Let's say there is information on Sheet1 consisting of 3 columns. When I write one of the information in the third column in a cell on Sheet2, I want the other two data in the row of the information to be printed. I would be glad if you help. ex: Get the name, age and citizenship...
  14. L

    Auto fill cells based on their color

    Hoping someone can shed some light on this, I am looking for a macro that would fill all the red cells with the text at the top of their respected column i.e AWV, CPE, CCM etc. I have not yet found anything that can recognize each individual column, always fills red cells with the same text...
  15. R

    Unable to automatically pull data and perform custom modifications to a table from a query whose source is a dynamically changing link

    * I posted this on the excel forum, but since this also relates to power query I also am making a post here. Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead...
  16. A

    Copying selected cells from one sheet 1 to an empty row in sheet 2

    I'm trying to figure out the code for copying selected cells from one sheet to an empty row in another sheet, this is what I have so far, but I cannot figure out how to make it so that it copys in next empty row, rather than replacing whats there Range("A24:G24").Select Selection.Copy...
  17. R

    Unable to automatically pull data and perform custom modifications to a table from a query whose source is a dynamically changing link

    Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead of manually typing out the inputs into the link, putting it into power query, performing transformations, and...
  18. Saher Naji

    Auto-Fill values (2)

    Hello O great and smart people actually I posted a similar thread before some days, and Mr. @alansidman graciously did a great help and his code is working very well, 100% and this is the post link for the solved problem: https://www.mrexcel.com/board/threads/auto-fill-values.1133259/page-2...
  19. B

    Moving to a previous sheet macro

    Hi, I have a macro that enables me to move to the previous sheet. However when back at the start I would want it to loop back to the last sheet in the workbook. The current code is displayed below and it checks for any hidden sheets and it misses out the first sheet which is the home sheet. Any...
  20. A

    Macro/Solver to assign correctly the correct quantity of purchased apples

    Hello everybody I will purchase a quantity of apples during the year, and 3 sellers made me their offers (quantity of apples and price per apple). Those offers are in sheets Seller 1, 2 and 3. So I need to determine what is the best combination among those offers, purchasing at the lowest...

Some videos you may like

This Week's Hot Topics

Top