Vba Related Problems & Solutions

83 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 83
[Solved] VBA to Stack The Data in Two Columns
Summary: I have 300+ rows of data in each of columns A and B and I would like to stack them, starting from row 3. As an example I would like this: A ...

Auto Highlight Selected Rows - VBA & Conditional Formatting
Summary: In a database with over 10000 rows it's hard to follow each row of data so I was wondering if there's a way to highlight them, but without "damaging" ...

[Solved] VBA Loop Range and Create New Range Based on Condition
Summary: I have a range defined in an Input box (oldRange). I use the code below to try and extract cell values in column A if the condition in column B is met...

[Solved] VBA to Create Array or Collection with Unique Values
Summary: This is related to https://www.computing.net/answers/o... When trying to clear Best Answer in the topic above, the message said to only clear if there...

VBA to Check if Email Sent/Not Sent and Display Text+Date
Summary: I have a code to generate and display an email using some data in an excel sheet. The email is generated based on an initial range of cells, let's cal...

[Solved] Extract Unique Values from Range Variable
Summary: I've been busting my head for hours now and I can't seem to find a code to work without having to use an actual cell range in the sheet. I've tried ar...

[Solved] VBA to Insert LastRow into a Formula to count Unique Values
Summary: I am using VBA to insert a formula which will count the unique values in a previously selected column. The formula is inserted in a cell of my choosin...

[Solved] Does anyone know where All Experts went?
Summary: All Experts was a great site and one of their Excel experts, Thomas Ogilvey, was incredible at vba and macros. I asked him so many questions and he w...

[Solved] VBA to Move String in Cells from End to Beginning
Summary: Hello, I have some values that represent a decrease of inventory and when pasting them in excel they come in the following form: 50- 140- etc. I made ...

[Solved] VBA to Generate Multiple Shapes Based on Number in Cell
Summary: Hello, I made a macro to create rectangles based on cell values for a 2D excel simulation. The code below adds the shapes once per each line I have in...

Using VBA/Macro for data entry
Summary: Hi there, hoping someone could help me out with this. I am currently working on a project that seeks to find out the most popular content posted on s...

[Solved] Macro to display message box once for each cell
Summary: Hello, In an excel file with various columns, I have a formula somewhere in column V that calculates a percentage. If this percentage is over 3% (...

[Solved] Macro to memorize dates in a column
Summary: Hello, Assuming I have an excel file in which I want to complete a year's deliveries that are made on a daily basis. I will take a simple example: - a...

[Solved] Macro to insert a formula in a column
Summary: Hello, Me again. I've been struggling today trying to make a macro to insert an INDEX-MATCH formula in a column (since I can't seem to make it work ot...

[Solved] Macro to remove some text with condition and add color shade
Summary: Hello, So I made a macro to format a table. I will post the macro below and there are comments that explain things. Here's how my table looks like: ht...

[Solved] How to edit an excel email macro to send only 1 email?
Summary: Hello, I got a macro online for sending emails given a condition. It works great if you have 1-2 entries that require email sending based on the cond...

[Solved] (Easy) Excel VBA Conditional copy paste components of a row
Summary: Hey there! I am looking for a way to automatically copy paste values from one sheet to another based on the contents of the column in the following wa...

[Solved] VBA copy a coumn contains certain charactor
Summary: Hello there.. Can I use VBA to copy column A to column B or C as below? Basically if it contains T511 it will copy to column B and if it contains PILC...

[Solved] Excel Macro to match set of values to another through edits
Summary: Hi folks! I've tried my hand with some macros and done OK but what I want to do here is beyond me and need your help! What I'd like to do is search th...

[Solved] Insert rows based on column count
Summary: I have data that I would like to write vba code to reformat. Specifically, I need to copy and transpose column data into rows. However, I do not want ...

[Solved] VBA Code for SavingAs excel sheet without Message box!
Summary: Hi, I am trying to saveAs a macro-enabled workbook to xlsx format. The problem is every time excel shows warning message when the macro button is clic...

[Solved] Can you maintain blank rows with a vba auto filter?
Summary: I have a worksheet with data that is automatically filtered when a date is entered in cell I1 via a Worksheet_Change(ByVal Target As Range) macro. Row...

VBA to AD - error after 1000 users
Summary: I am currently working on a project to query AD , I have a script that do that, but the script is failing after 1000 users , while the users I am quer...

[Solved] How to add $ sign automatically in the formula in MS Excel
Summary: Hi, I have an excel worksheet containing column A to M with data from row 2 onwards. E.g. For row 2, value in M2=K2+L2 and row3, value in M3=$M$2 For...

[Solved] Check & set the start date after another task end in excel
Summary: I have a schedule control Excel sheet, such as below Item Task Start End "predecessor task" 1 Gather requirement 2016/5/3 ...

Copying data to another worksheet based on criteria. - VBA
Summary: Maybe I'm just over thinking this, but I couldn't find anything about it anywhere. What I'm trying to do is copy a range of cells from a table on one...

[Solved] Vba CodeCopy certain value of cell from column
Summary: Hi I am having difficulty to right vba a code which is below there is a huge data set in column C:C of which i have to work with 165 values which come...

[Solved] How to match value in separate sheets and copy/past the row?
Summary: Hello everybody, So basically the situation: In the sheet1 (master reports) column A i have code such as AAA-12122 and then all details in the other ...

[Solved] VBA code to insert new row and copy from row above
Summary: Hi, I have 100 groups of data. Group1: 10 rows of data in row 2 to 11 from ColA to G. Cell A2 to G11 have been filled up. Group2: 25 rows of data in r...

[Solved] VBA code to copy cells to X-number of rows lower for X-times
Summary: Hello all Can anyone help me with this Little VBA script: I need to be able to select a cell, then run the macro and that macro will then copy the cel...

123


Ask Question