Recent questions tagged vba

0 votes
1 answer

Do Until replay tree times

Feb 13, 2023 in Others by Kithuzzz
 • 38,000 points • 820 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 933 views
0 votes
1 answer

How do ask ChatGPT with API from Excel macros (vba)?

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 2,449 views
0 votes
1 answer

Exclude worksheets from loop with a list

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 423 views
0 votes
1 answer

Sort numeric values VBA

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 580 views
0 votes
1 answer

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 560 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 923 views
0 votes
1 answer

Hide or visible sheets

Feb 10, 2023 in Others by Kithuzzz
 • 38,000 points • 863 views
0 votes
1 answer

Generate number by using Dynamic array (w/o VBA)

Feb 10, 2023 in Others by Kithuzzz
 • 38,000 points • 460 views
0 votes
1 answer

Close One Tab within Chrome via VBA

Feb 10, 2023 in Others by Kithuzzz
 • 38,000 points • 2,352 views
0 votes
1 answer

Finding duplicate values in 5 excel sheets and results to be moved in the sixt one

Feb 10, 2023 in Others by Kithuzzz
 • 38,000 points • 431 views
0 votes
1 answer

EXCEL Userform - Creating multiple Labels and Textboxes with specific names

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,423 views
0 votes
1 answer

Having trouble hiding activecell column across tabs using vba

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 843 views
0 votes
1 answer

VBA Project creating a subroutine for activcell

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,372 views
0 votes
1 answer

How can I stop my vba code from giving me an error 424?

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,036 views
0 votes
1 answer

Excel VBA - Out of memory when create a dynamic array formula

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 872 views
0 votes
1 answer

How can I rename each column of a table?

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 797 views
0 votes
1 answer

How can increase the speed of if statement in VBA Code?

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 668 views
0 votes
1 answer

VBA - user input of row value to use in a cell range

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 593 views
0 votes
1 answer

Excel VBA compare values on multiple rows and execute additional code

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 2,196 views
0 votes
1 answer

VBA How do I replace the range with an array in SUMIF

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,071 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Feb 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,097 views
0 votes
1 answer

Copy the respective values from another workbook depend on specific conditions

Feb 6, 2023 in Others by Kithuzzz
 • 38,000 points • 823 views
0 votes
1 answer

VBA Excel: Draw line between cells based on cell value

Feb 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,796 views
0 votes
1 answer

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 460 views
0 votes
1 answer

How do I make my subs() not change inputdata in Vba excel

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 756 views
0 votes
1 answer

How to copy entire data using row by row and paste to another sheet

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

VBA Excel: Write timestamp to cell on change of another cell

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

Autofill macro to autofill dates up to 31 days regardless of the month

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 413 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

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

Excel Visual Basic managing coordinate tuple type

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 914 views
0 votes
1 answer

VBA reordering columns from different workbook or sheet

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 451 views
0 votes
1 answer

How to increment a column value if it repeats, otherwise reset to 1?

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,072 views
0 votes
1 answer

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,040 views
0 votes
1 answer

Having issues with pop-up alert in excel. (Visual Basic)

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 834 views
0 votes
1 answer

Insert multiple columns to the right in sequential order

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 599 views
0 votes
1 answer

Excel VBA Scheduled message pop up box reminder

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,378 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 528 views
0 votes
1 answer

How to arrange a string to display

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 728 views
0 votes
1 answer

Getting data out of a cell with a #NAME? error in Excel VBA

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 823 views
0 votes
1 answer

Find value in column where running total is equal to a certain percentage

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 478 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

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

How do I copy a specific range of cells after I use AutoFilter in VBA?

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,101 views
0 votes
1 answer

Divide a range of values for each unique value

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 458 views
0 votes
1 answer

Excel VBA - Need to get a specific line from TextBox and send to an specific Cell

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 811 views
0 votes
1 answer

Extracting info from hyperlink

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 411 views
0 votes
1 answer

Want to create a chronological row # then reset based on font color

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 374 views
0 votes
1 answer

2D rotation of an object along a custom axis

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

How can I allow a user to change a cell in excel only under particular conditions?

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

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Jan 31, 2023 in Others by Kithuzzz
 • 38,000 points • 792 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.