Recent questions tagged vba

0 votes
1 answer

Do Until replay tree times

Feb 13, 2023 in Others by Kithuzzz
 • 38,000 points • 592 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 • 753 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,148 views
0 votes
1 answer

Exclude worksheets from loop with a list

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

Sort numeric values VBA

Feb 11, 2023 in Others by narikkadan
 • 63,600 points • 465 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 • 447 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 • 721 views
0 votes
1 answer

Hide or visible sheets

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

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

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

Close One Tab within Chrome via VBA

Feb 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,968 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 • 343 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,223 views
0 votes
1 answer

Having trouble hiding activecell column across tabs using vba

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

VBA Project creating a subroutine for activcell

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,111 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 • 896 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 • 736 views
0 votes
1 answer

How can I rename each column of a table?

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 556 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 • 533 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 • 457 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 • 1,862 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 • 876 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 • 908 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 • 608 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,468 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 • 356 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 • 544 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,522 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,021 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 • 325 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

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

Excel Visual Basic managing coordinate tuple type

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

VBA reordering columns from different workbook or sheet

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 383 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 • 815 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 • 913 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 • 656 views
0 votes
1 answer

Insert multiple columns to the right in sequential order

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

Excel VBA Scheduled message pop up box reminder

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,097 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 • 421 views
0 votes
1 answer

How to arrange a string to display

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 592 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 • 653 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 • 364 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,177 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 • 863 views
0 votes
1 answer

Divide a range of values for each unique value

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 360 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 • 691 views
0 votes
1 answer

Extracting info from hyperlink

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 346 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 • 294 views
0 votes
1 answer

2D rotation of an object along a custom axis

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