2022 Developer Survey is open! Take survey.

Questions tagged [macros]

A macro in computer science is a rule or pattern that specifies how a certain input sequence should be mapped to a certain output sequence according to defined rules and procedures. Consider using [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the people answering, filter questions more efficiently.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

Using data slicers and advanced filter for the same table in excel

I've got one table which I filter by some slicers. Although, I want to use also an advance filter on the already filtered table. I'm using a macro to start the advanced filtering, which can be started ...
user avatar
0 votes
0 answers
25 views

How to unhide rows in an Excel spreadsheet depending on the contents of a separate cell using VBA

I'm working on a checklist for work, and I want to be able to unhide rows below a question based on if the answer to the question is yes or no. I.e. if it's yes, unhide these rows, if its no, keep ...
user avatar
0 votes
0 answers
15 views

I cannot seem to write to a newly opened document

Enclosed is an extract from a macro in Document startx.docx. The first part of the macro places some strings in the array sntc(1) to sntc(s). I now want to write these strings on to a new document, ...
user avatar
0 votes
0 answers
12 views

How to enable a specific data connection via VBA in Excel 2016

I'm building a worksheet that will automatically run a web query. Ideally, this will run automatically, without any user intervention. But sometimes the connection is blocked by Excel's security ...
user avatar
0 votes
1 answer
28 views

How to make a button copy data from a cells to a table

I'm making a machine move tracker in work, but I'm new to excel coding. I have multiple sells of data I want to insert to a table with the click of a button, image attached of the input data form. any ...
user avatar
0 votes
0 answers
26 views

Sending Keystrokes/Macro to a connected device?

Currently I'm trying to automate a bit of work I've been handed. Basically, it's a device where I need to put in the same values over and over again, though with a variable for it (Serial and MAC). ...
user avatar
0 votes
1 answer
15 views

I have a worksheet with multiple tab and i want to separate each tab that contains same text into a separate sheet

I have a worksheet with multiple tabs, can i get a VBA code that will separate each tab into multiple files I want to make A1 and A1 SCREEN as one file, then B1 and B1 SCREEN be on another file and ...
user avatar
0 votes
1 answer
23 views

Delete Specific Rows from Excel from a List of Row Numbers

I have a worksheet with 83,188 rows and 4 columns of data. I have another worksheet that has a list of row numbers (eg 18751, 9127, 696, and etc) that signify the rows I would like to delete from the ...
user avatar
0 votes
0 answers
10 views

How to set the keyboard key to run erase function in the stylus pen?

ONE BY WACOM PEN S (CTL-472/K0-CX) I found that it could set the button on the pen to erase instead of drawing. And it works with many apps such as PDF reader in Microsoft Edge, and Microsoft Paint. I ...
user avatar
  • 1
1 vote
1 answer
28 views

How to append to formula if a condition is met in microsoft excel?

I have a bunch of formulas dotted about my excel tab that are of the form: =cell_1+0.0049>SUM(cell_2:cell_3) for example- =O10+0.0049>SUM(H10:N10) I want to find all instances of these cells and ...
user avatar
0 votes
0 answers
13 views

In word, is there a reference from ribbon function to VBA?

I am maintaining a macro collection for myself with common tools I use in manual writing. When I need a function often, it's added. Commonly I struggle to find which function in VBA matches the ...
user avatar
  • 117
1 vote
0 answers
15 views

Win10 - Excel 2010 - Need macro to place hyphens between each letter of a single Hebrew word in a cell

The goal is to separate each Hebrew letter of each word of the Tanach/Old Testament into separate cells. If I manually place hyphens between each letter in a word, then Text to Columns will place each ...
user avatar
  • 111
1 vote
1 answer
53 views

Why does MS Excel change my conditional formatting rules when run as a macro?

I have some pretty standard conditional formatting rules set up to help monitor my organisations printer toner levels. When the rules are applied "manually" everything works fine and the ...
user avatar
  • 11
0 votes
1 answer
27 views

Remove Macro References in .XLS Files

I have been playing around with how to remove Excel macros using PowerShell and COM objects and have had success in doing so, however, I noticed that for .XLS files, there is a reference to the name ...
user avatar
0 votes
1 answer
31 views

Macro is not copying data validation in the cells

I have a macro to copy a selection from a sheet and email it as a separate attachment, however it is not copying the data validation that exists in those cells. In the sheet there is validation that ...
user avatar
0 votes
1 answer
34 views

Formula to compare cells in 2 different sheets, copy text and highlight new or updated cells using different colours

I am looking for some help with a Macro in excel. 1 workbook with 3 worksheets in it. Worksheet1 & 2 (WS1 & WS2) has data copied from a business reports. WS3 has a consolodated view so all of ...
user avatar
  • 11
0 votes
1 answer
33 views

Create Repeating List From Two Sets of Data

I have a list of employees (A1:A100) and a list of initiatives (B1:B4). I'm trying to make a list where I have each of the four initiatives assigned to each employee in separate cells like this: ...
user avatar
0 votes
1 answer
40 views

why do DOCX documents open in protected view if they can't run macros

There are 2 kinds of Microsoft word documents. DOCX (documents that can't run macros), and DOCM (documents that can run macros.) Whenever I Download and open a DOCX document anywhere on the internet, ...
user avatar
  • 101
0 votes
1 answer
25 views

How to add a linefeed in VBA macro

I am new to VBA macro and need advice on the following code. [Excel cells] Sub Create_email() Dim OutApp As Object Dim OutMail As Object Dim strName As String Dim strTo As String Dim strCc As String ...
user avatar
0 votes
0 answers
11 views

Phrase Express - Make clipboard Url compatible

I want to get the content in clipboard Url compatible Like replace space or accent I can find how space is represented in phrase express . I tried a literal space in the field but don't work I tried ...
user avatar
0 votes
0 answers
23 views

How to run a macro automatically?

I have a macro that runs great except that I have to manually run it. The macro will hide all the columns that are not "true" based on a value in a cell. Here is the macro I have: Sub ...
user avatar
0 votes
1 answer
11 views

Excel macro to highlight common values between two different sheets

I'm having list of account numbers(AA, AAB, AAC, ADC) in column A in sheet 1 and also I'm having some common account number in sheet 2 (AAB,ADC)which is already available in sheet 1. Now i need a ...
user avatar
0 votes
0 answers
136 views

How to make mailto hyperlink with custom body using VBA?

I'm trying to find a simple way to send a pre composed e-mail when a hyperlink is clicked. I've also tried this without VBA just as a formula. But I keep exceeding the 255 characters. (For this ...
user avatar
0 votes
1 answer
52 views

How do I create a macro to delete a table row based on a range of cells which all have identical values

First off, I'm sorry if this is answered somewhere else. I've searched through the site and can't find anything that seems to answer this question for my needs. I'm completely new to macros, this will ...
user avatar
  • 3
1 vote
0 answers
28 views

Remove lines with less than X number of letters from Microsoft Word (2016 or higher)?

I'm using MS office 365. I have a big MS word document containing more than 10000 lines. The document has some meaningless lines that contain meaningless alphabet letters, unknown Asian letters, ...
user avatar
  • 125
0 votes
0 answers
49 views

How to hide certain columns when another cell shows a specific text

This is what I want to happen: If Cell F6 is blank does nothing. If Cell F6 the Cell has specific text saying 'A' only then I want full columns N, O, Q, T and U to be hidden, the whole columns hidden. ...
user avatar
  • 1
-1 votes
1 answer
53 views

I have a large worksheet with many columns. How do ! find specific columns - headers- and their contents and bring them to the beginning of the sheet?

I have a large worksheet with many columns. How do I search specific columns return them to the beginning of the same sheet from B1? I am using this for an automated weekly task that does not have a ...
user avatar
0 votes
0 answers
33 views

PowerPoint VBA: Merge 1000 Presentations, preserving formatting

I need to merge many (around 1000) PowerPoint presentations into one. My presentations have different extensions, some are ppt and some are pptx. I need to merge them with VBA Macros preserving source ...
user avatar
0 votes
1 answer
105 views

Notepad++ perform multiple actions to multiple files at once

I have like 20 subtitle files where I do these actions one by one: Encoding > Character Sets > Central European > Windows 12-50 (ctrl+shift+E shortcut) Encoding > Convert to UTF-8-BOM (...
user avatar
0 votes
1 answer
36 views

How to paste a character with Microsoft Keyboard Macro system?

I have a SideWinder X4 keyboard, and it supports the awesome Mouse and Keyboard Center app. I write a lot of location-based text/code, and frequently have to open the Character Map app, find the ...
user avatar
0 votes
2 answers
42 views

Function to create a specific cell value format for daily use

I am not an excel guru by any means, therefore would like support in creating a function for the following: We have a column for category trees in the following format in our sheet: Example category ...
user avatar
0 votes
0 answers
78 views

What arguments to use in a Loess macro for Excel?

I have found a macro on a forum which is a smoothing filter called Loess for time-series data. However, I am unable to run the macro properly as I'm not sure what the arguments are. Here is the data I ...
user avatar
  • 113
0 votes
0 answers
18 views

Automatically Log Into Windows 10 At Specific Time

I am trying to run a macro to upload file to an website once a day on the weekend. I have created a macro with Pulover's Macro Creator that was successful in this. My issue now is trying to find a way ...
user avatar
  • 1
1 vote
1 answer
13 views

QuicKeys: Can't assign Enter or Tab as hotkey

I'm having the problem of trying to assign either the Enter, Return, or Tab key as a hot key for a shortcut in QuicKeys, with or without any modifiers. It doesn't seem to recognize these keys.
user avatar
  • 1,933
0 votes
1 answer
36 views

Constant (or macro) definition for a BIND9 zone database

I am using BIND9 on a Linux system. In my zone db files I have multiple occurrences for the same IP in multiple IN A entries. For example, my www, mail, ns, etc., IN A entries refer to the same IP ...
user avatar
  • 334
0 votes
1 answer
24 views

How to assign a name to a symbol in an Excel macro

In the formula bar in Excel I'd like to block..copy a symbol, assign to it a name, and then use an IF function to determine what to do next; i.e. if NAME is "-", then do A, if not, then do B....
user avatar
0 votes
1 answer
83 views

Put binary numbers per row one by one

My aim is convert decimal number to binary numbers and putting binary numbers one by one per column in EXCEL. I did convert decimal to binary using BASE command and do not know how to put it one by ...
user avatar
  • 1
2 votes
1 answer
146 views

Excel macros won't run from shapes or buttons

Using Excel 365. My workbook has macros which are linked to buttons or shapes on several worksheets. The macros work if I run them from the Macros dialog, or the VBA editor, but when I press a button ...
user avatar
-1 votes
3 answers
95 views

order two columns off another two columns

I would like to order two columns off another two columns. Consider the image: I would like to order column C and D based off column J and K. For example, the order should go something like John Brew,...
user avatar
  • 3
0 votes
0 answers
26 views

Renaming files by middle clicking?

Is there any way to set up windows explorer so that I can rename files by clicking on them with the middle mouse button? I'm tired of having to slow double click or use the right click menu. (Please ...
user avatar
0 votes
2 answers
43 views

Is there a way to automatically format an excel cell to a friendly hyperlink when a user pastes in a full URL?

I am building out a spreadsheet where I want to paste in a long and ugly link into a cell. I would like automated formatting to take place that will take that long link and create a "friendly&...
user avatar
0 votes
1 answer
32 views

Explanation to understand a VBA code for percentage change

I am learning to create formulas in VBA from the internet, and I came across this article by Jon from excel campus where he was teaching to create formulas for the percentage change. I, however, was ...
user avatar
  • 5
0 votes
1 answer
28 views

Excel 2013 fails to record macro correctly

So, i want to create a macro that will set selected cells' format to 0,0 ¥. However, if you record the steps and then try to run the macro it will set format to 0,0 ?. Is there a way to fix this?
user avatar
  • 1
0 votes
1 answer
200 views

Need a Excel VBA loop code for copying and pasting a range

I want to make a loop for copying range A6 to B 2365 and pasting it 18 times below the previous range, i.e, I want to paste it right below the previous range so if the first range ends in row number ...
user avatar
  • 5
0 votes
0 answers
23 views

Excel VBA suddenly doesn't recognize non-declared variables and some functions

We recently had one of our servers migrated to Azure with a Bastion VM connection. A number of macro based Excel workbooks sit on the server and have stopped functioning as they used to. I'm getting ...
user avatar
  • 211
0 votes
1 answer
269 views

Auto delete a value after a certain date is passed

I'm making a work registration list for myself and my colleagues.  In this workbook I created, we have a certain amount of free days we can use, but we need to use those free days before a certain ...
user avatar
  • 1
0 votes
0 answers
46 views

Macro to fill in cells from a range everytime I click on a button

this is my code for trying to fill cell from the range i have but unfortunately everytime i press the button the array is filled totally xith "x" and not one at a time. Can anyone help me ...
user avatar
0 votes
0 answers
33 views

How can I automatically download web pages for offline viewing?

I am writing a macro; but at some point i need help. What I want is to download pages in bulk for offline viewing. I used IDM; but the pages seem to be missing when viewing the files after downloading....
user avatar
  • 3
0 votes
1 answer
34 views

Excel : how sequential analysis and incremental counting? formula or macro?

i would like to know if there is a way to analysis occurrence of words in a column in a sequential way. it is little bit complicate so here an example i would like to achieve: here below is my colomn ...
user avatar
0 votes
0 answers
39 views

Excel: Merging multiple Rows & adding/Columns based on one repeated cell

Every other month have I have to clean up a spreadsheet. I've been doing it manually and it takes me about 4 hours. The pictures below will help visualize what I need. Based on the value on column &...
user avatar
  • 1

1
2 3 4 5
33