Recent questions tagged vba

0 votes
1 answer

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

Jan 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,345 views
0 votes
1 answer

How do I show the computations after S/N 1048576 in a separate sheet

Jan 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,020 views
0 votes
1 answer

To Keep only 1 header while merging Multiple file

Jan 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,779 views
0 votes
1 answer

Searching Multiple Criteria In Large Data Set to make new Data Set Excel VBA

Jan 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,779 views
0 votes
1 answer

Excel links keep crashing

Jan 30, 2023 in Others by Kithuzzz
 • 38,000 points • 1,324 views
0 votes
1 answer

Copy the time to the next row of another column

Jan 30, 2023 in Others by Kithuzzz
 • 38,000 points • 1,158 views
0 votes
1 answer

Can not get bubble sort to run in excel's developer mode

Jan 30, 2023 in Others by Kithuzzz
 • 38,000 points • 848 views
0 votes
1 answer

How to get the total of every monday to saturday or tuesday to sunday in a month dynamically

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,359 views
0 votes
1 answer

Excel to Word Macro resulting in Run-time error 462

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 2,156 views
0 votes
1 answer

Select a range in Excel based on the value of a cell

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,591 views
0 votes
1 answer

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,238 views
0 votes
1 answer

Iterate thru specific controls in a form using a loop

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,015 views
0 votes
1 answer

How do I find top row visible on Sheet in Excel

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,117 views
0 votes
1 answer

VBA How To Paste With Blank One Column Over?

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,147 views
0 votes
1 answer

Sum the total of a column in excel and paste the sum to a different workbook

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,770 views
0 votes
1 answer

Excel - return a value only if a condition is met via VBA

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,644 views
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 4,922 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,344 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,400 views
0 votes
1 answer

Multiple Select Case Statements in a Single Procedure

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 893 views
0 votes
1 answer

VBA, Loop through sheets not detecting parameters?

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,138 views
0 votes
1 answer

VBA Create and Rename Tables

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 2,207 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 2,213 views
0 votes
0 answers

VBA Excel MID Function Array

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,076 views
0 votes
1 answer

Get inserted image to adjust the row height in Excel

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,199 views
0 votes
1 answer

Attributing the value of a cell based on another corresponding cell

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,238 views
0 votes
1 answer

What VBA Code to Hide Excel Quick Access Toolbar?

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 2,272 views
0 votes
1 answer

Changing code to adjust number of charts on each powerpoint slide VBA

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,568 views
0 votes
1 answer

Automating production of graphs using VBA

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,977 views
0 votes
1 answer

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,198 views
0 votes
1 answer

Excel VBA If range.value = something then fills Columns G

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,127 views
0 votes
1 answer

Split and group values in excel

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,297 views
0 votes
1 answer

Macro that deletes all asterisk signs from cells

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,208 views
0 votes
1 answer

Excel VBA: Auto increment cell value after each printing

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 2,471 views
0 votes
1 answer

Public variable for captura path in vba excel

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,481 views
0 votes
1 answer

How to do multiple transpose in excel vba

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,343 views
0 votes
1 answer

VBA code to take some string components, search them inside a workbook and replace the components with the cell addresses found

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,108 views
0 votes
1 answer

Why is a Variant parameter changing its type on function call

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,035 views
0 votes
1 answer

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 2,311 views
0 votes
1 answer

Excel VBA userform paste text in expanded format (not just to one cell)

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,382 views
0 votes
1 answer

My VBA macro slows down dramatically with each use

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,470 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,573 views
0 votes
1 answer

How to add if this cell = 0 skip and go next

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,157 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 3,203 views
0 votes
1 answer

Comparing data in Excel

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,235 views
0 votes
1 answer

How do I get it to select a single row based on the value?

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,385 views
0 votes
1 answer

VBA copy data from other file - problem with file name change

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,341 views
0 votes
1 answer

VBA Code Help - Need to add a line for each missing date and copy data from cells below

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,328 views
0 votes
1 answer

Using VBA Workbook_SheetChange only works in one direction

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,268 views
0 votes
1 answer

How to make a auto counter to print pages

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,266 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.