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
0answers
14 views

Format Result of VBA code respective to row

I have below sheet I am using below code to get reports in different sheet for Blank cells which Sub Loop_Column_Row() Dim lRow, lCol As Long 'Counter Dim i As Integer 'Find the ...
0
votes
1answer
17 views

VBA code to generate report of blank cell in different sheet

Hi how i can modify below code so all blank cells value are generated as report in different sheet , taken this code from my different post which i posted earlier ! but found it will end if it find ...
0
votes
0answers
16 views

Macro validation and conditional check

i have below excel where i want to do data validation for ColumnName1 ColumnName2 ColumnName3 & ColumnName4 and as well check the condition if ColumnName6 = ColumnName7 && ColumnName5 = ...
0
votes
0answers
9 views

Libre office Basic shortcut keys within a macro

I've created a macro that opens a folder based on which cell is selected. I've made it so that the macro is linked to a push button, but this can be cumbersome to find if the sheet is large. I set up ...
0
votes
1answer
29 views

Conditional Formatting in cell based on cell value

i am trying below formula to get value of column B all cells ,before hyphen and want to check if before hyphen character len is 8 make it green else red but not working as expected i am using ...
0
votes
2answers
58 views

How to format part of a figure caption in MS Word bold, and the other part regular?

I would like to generate figure captions as displayed in the image below. The figure caption should contain 3 parts: Part 1: Automatic numbering including chapter number and figure number. Font: ...
0
votes
1answer
25 views

compare values in excel and highlight the leading number in B1

how do i compare column A which has repeats data against column B which has numbers and highlight the leading number. since the data has no patterns, not quiet getting it, Please help.
0
votes
1answer
40 views

message box for empty row in excel

i have large excel with many rows which can increase in future ,so i want to identufy the way if on button click i can check if any field is empty , i tried below macros with checking cell value and ...
0
votes
1answer
124 views

Need help to add symbols automatically to a long list of cell values

I have a long row of SYMBOLS. Example: AAA BBB CCC .. .. Etc. I need to add " " around the symbols and I need to ad a comma at the end of the symbol. My row should look like this: "AAA&...
0
votes
0answers
22 views

kinda complicated autohotkey action, is this possible?

for example ctrl + a → send f10 while ctrl is held down and until ctrl is being relased, next press of "a" sends "capslock", 2nd, 3rd, 4th etc and when ctrl is released, it's all ...
0
votes
0answers
12 views

Is there a way to activate AND deactivate my screensaver on command? (Windows 10)

I need to find a way to activate and also deactivate my screensaver on command, preferably to have a hotkey for activation and one for deactivation, so the screensaver will stay even if there is mouse ...
0
votes
0answers
16 views

Excel cursor stuck in cell after one macro runs but not another

I am working on a scan sheet for verifying 3 different barcodes for the same part. The first field is for the master scan, the second verifies that the correct parts, and the third verifies the labels....
0
votes
1answer
16 views

Copy a range of sheets from Sheet “Cover Sheet” to Sheets.Count into a new workbook

I am trying to create a "client friendly" version workbook that will include all tabs from "Cover_Sheet" to the final sheet. The workbook has a macro to copy the "value" ...
0
votes
1answer
56 views

Microsoft Excel - Copy entire row from different sheet based on multiple criteria

Okay, I've been trying to find this answer for a while and I can't quite get it using formulas specifically as it would require more than the formula bar could hold and I have zero experience with ...
0
votes
1answer
22 views

Macro to Remove Spacing Between Graphics/Text in Word 2010 Document?

I frequently create Word (version 2010) documents that have only graphical items, and occasionally with some text beside a graphic, such as "New!" (that I would like to keep). I would like ...
0
votes
1answer
27 views

Need help processing opened images in ImageJ

I've created a macro (based on different ones I've seen) that analyses particles areas in my picture, automatically copies the Area column in the results window to my clipboard and displays a window ...
0
votes
1answer
23 views

Autofill down variable number of rows in a macro

Here is a mock version of my data. There are two worksheets: and Column A is a TEXTJOIN function. The rest is filled in manually with the exception of the year. I want to get the year by using a ...
1
vote
0answers
22 views

Is there a way to have voice assist with direct keyboard commands?

I’m not looking for a dictation app, unless it also has this feature. Essentially, I could say something like Ctrl + C and it would copy. A similar question was asked before, but unfortunately the ...
0
votes
1answer
32 views

Excel VBA - Copy Rows by Unique Value in Column A

I have managed so far to pull all my data from different sources into a “Master List”. From here I would like to pull all rows with matching values from column A into its own sheet. I.E. All rows ...
0
votes
1answer
29 views

Excel macro to show formula with numbers and operators

I learned recently about the & and "" and their usage in making an autoupdating formula. What I mean is, for example I have 3 numbers, 1, 2 and 3 and I sum them in a cell with =B3+B4+B5, ...
0
votes
1answer
19 views

Excel - Macro - Data copying with values

I have a macro where it copies a range from a sheet and pastes it into another sheet. Sheet name - MAIN Range - C4 - D26 Date sheet - DATA Then when you enter new data and use the macro, it copies the ...
-2
votes
0answers
27 views

What's the best way to listen for Windows toast notifications (and execute rules)?

Are there any ways to listen for toast notifications and execute rules-based actions? My goal is to trigger certain actions when I receive Your Phone notifications, and I know some applications write ...
1
vote
2answers
35 views

Mirror a group of cells elsewhere in the same sheet

I am trying to have an interactive table multiple places in my sheet to prevent my users from having to scroll repetitively through this massive sheet. every time this table is updated from any of the ...
0
votes
0answers
29 views

Macro not showing up before VBE is open

I've added a VBA module to an Excel workbook and saved the project as an XLSM file. One of the subroutines was defined such that it shows on the Macro list (the one opened by Alt+F8). When I open the ...
0
votes
0answers
16 views

Compile a LIST in one worksheet using data entry from another sheet on same workbook

In an effort to not have the list of all persons in full view due to some wanting to keep information confidential, I wish to create a separate sheet where either using macros or formulas values ...
1
vote
2answers
48 views

Pivot auto date filter in vba

I have issue while filter today date in VBA. Because the format changed for each user. How to set it as universal format? My code: 'FILTER TODAY DATE IN PIVOT Private Sub Worksheet_Activate() On ...
1
vote
1answer
36 views

VBA For loop skipping the first iteration

I'm trying to write a macro to detect if a cell contains a certain word. If yes, copy the entire row to the next empty row. In this case, I'm trying to detect "60s" from "Full Length, ...
0
votes
1answer
24 views

Introduce pop up message when macros execution is complete

Below is current VBA instructions. Would like to add a message at end to let user know when macro is done such as "Done" , "complete" or "Now please go to step 3" Sub ...
0
votes
1answer
34 views

How to create a Destination file that is linked to a Source on Excel offline?

I am struggling with an excel feature regarding creating a Source and Destination workbook. My Source data comes from the web using which I must create dashboards on Power BI. But before that, I make ...
0
votes
1answer
59 views

Macro to create Line graph for each row in my table?

I've got a monthly spend table with almost 800 rows (one row per customer), and I'd like a line graph, with trend, for each customer. Is there a Macro that will help me do this for every line, and ...
0
votes
1answer
35 views

Unable to use Filter macros across all worksheets due to different table names assigned by Excel

Looking to create a filter on column D to have "NO" and column E "blanks". I have done these by recording a macro as shown below. However, I am unable to create a macros button and ...
0
votes
1answer
46 views

Inconsistent Column Range

Created a macro on a table with rows which auto expand depending on what is input. The original range of column D which i am working on is D2:D12. On some occasions, the range will go beyond D12. It ...
-1
votes
1answer
26 views

how to Hyberlink many cells with pdf files automaticly

Is there any method to hyberlink a large amount of pdf files into excel column without repeating (hyberlink for just one file) manually for each cell ?
0
votes
0answers
31 views

OneDrive Seemingly Deleting Macros

We have a large, complex workbook that is sync'd across 4 users with OneDrive. Almost every week, we'll open the workbook and it will be corrupted - usually all of the macros have disappeared. The ...
0
votes
1answer
16 views

To hide all rows when value is 0 in column I depending on a dropdown list in Cell D3

I have a dropdown list in cell D3. Once you change D3 the rows values changes some with numbers over/under 0 and some remain a sharp 0 in column I. I need a Macro which will loop and the result should ...
0
votes
0answers
12 views

Update Excel Macro to change wording in Created Email, but new wording will not update when I click in the excel cell

I have an Excel workbook that when I enter a date in a cell it creates an email. I changed some of the wording in the email and update the Macro and VBA code to reflect these changes. If I run the ...
1
vote
3answers
54 views

Transposed counts for many columns

The input: I have to get the count of the number of '1' and '0' in each column like this: Is there any way in Excel/macro to do this?
1
vote
1answer
70 views

How to create a macro in Notepad++ that will save a file as a different name?

In Notepad++, how can you create a macro that will save the current file with a different name? When I use the macro recorder in Notepad++, it doesn't seem to record any Save operation. Ideally, I ...
0
votes
1answer
109 views

Is it possible to know if the field in Excel is raw value or two numbers added together

Meaning... I have b5 with value 345,33 and b6 with value 22,00+12,00 which Excel correctly calculates as 34,00 BUT I need to know if the 34 is result of adding or just a plain number like in b5 ? ...
0
votes
1answer
16 views

Import data from existing word document to new one automatically

all, I would like to import data from an existing word document into a new word document automatically based on stored values inside variables. Eg. var 1 - text 1, var 2 - text 2 etc I want this ...
0
votes
1answer
24 views

Is there a way I can reformat numbers in a Word document?

I would like, under Microsoft Word 2019, to replace an italicized counting number followed by a space with the same number in superscript. So, for instance, <em>27</em> would be replaced ...
1
vote
1answer
27 views

How to use file path stored in a cell in another cell to refer to a value in excel

I have a macro that loads the path of a file to a cell dynamically, Let's say the cell is C1. C1 contains File Path: "/a/x/c/s" How do I use the value stored in C1 in other cells to get the ...
1
vote
1answer
21 views

MsgBox based on 2 values in different cells

I am completely a VBA novice and am trying to achieve the following, without success.I would really appreciate your help. What I need to achieve: If someone selects for each row Action = "Delete&...
0
votes
0answers
27 views

Macro to merge cells in all adjacent rows after searching cell value

I need help to design a macro that can merge all respective rows as per the merged cell after searching text value for that merged cell. I tried a lot vba code but nothing seems to work for my ...
0
votes
1answer
94 views

Converting PowerPoint with complex text to a Unicode text file

I found the following macro code for converting a PowerPoint file to a text file: Sub ExportText() Dim oPres As Presentation Dim oSlides As Slides Dim oSld As Slide 'Slide Object Dim ...
1
vote
1answer
24 views

Outlook Blank Subject Crashes Rules… VBA to Resolve doesn't show in Scripts list

So there is a known bug in Outlook, where my blank subject lines in incoming rules on IMAP&SMTP accounts cause forwarding rules to error and crash, and ultimately disables the rule. I thought a ...
0
votes
0answers
32 views

Extracting data from a CSV file

One of my tasks at my job is to take readings from the floor PDUs and compile the data into a masterfile. There's 32 CSV files by the time I'm done gathering them all. I recorded some macros to make ...
0
votes
2answers
44 views

How to calculate the total logged hours per person per week per month?

I have a table which calculates the total logged hours per week per person. The Excel file has the following structure: table where the desired values are calculated table with days of the month ...
0
votes
1answer
29 views

Using Match() instead of Find() in Excel macro

I've been using a macro for about 11 years without any problems. However, over the past 18 months some of the workbooks I've been using it on are very large and in these cases the macro can take a ...
0
votes
1answer
14 views

Excel: Finding the sum of a 3rd row by comparing rows that have 2 matching columns

I have a workbook where we have monthly phone bills broken down by line and funding codes. There's over 200 lines on this file and growing. I need to find the sum of any rows that have the same cost ...

1
2 3 4 5
32