No announcements
Found 2876676 threads
-
0 Votesmacro to loop column
hi, Question : I need help on below macro to loop column. Process : i have two sheets one is Calendar and second is ...Answered | 2 Replies | 409 Views | Created by 5Ant - Saturday, September 16, 2017 6:22 PM | Last reply by Terry Xu - MSFT - Tuesday, September 19, 2017 9:35 AM
-
0 Votes
VB Macro to loop through a list (column) of dates
Activate cell A1.Select all cells (click the button to the left of the "A" column header).On the Home tab of the ribbon, click Conditional Formatting > New Rule...Answered | 2 Replies | 4213 Views | Created by TheOtherSid - Wednesday, July 4, 2012 8:48 PM | Last reply by TheOtherSid - Thursday, July 5, 2012 2:06 AM -
0 Votes
Sharepoint 2013 Column Limits
reference more than one time in a data macro, is it counted more than once? If I loop through queries that contain only the specific columns needed for reference ... -
0 Votes
Remove $ sign from cells in Excel Spreadsheet using macro/VBA
Sub remove_dollar_sign() ' Macro to remove $ from beginning of cell values ' Run Macro by pressing Ctrl+Shift+D ' Use ...Unanswered | 1 Replies | 6621 Views | Created by sunshine19992 - Friday, September 7, 2007 3:58 AM | Last reply by magicalclick - Friday, September 7, 2007 6:15 PM -
0 Votes
VBA to populate numbers in Excel
column) and a line number (right column) which is blank. The macro will read the left column and populate the right column with 1's and then populate the ...Answered | 2 Replies | 4546 Views | Created by meridius10 - Sunday, December 6, 2009 11:47 AM | Last reply by meridius10 - Friday, December 11, 2009 7:35 PM -
0 Votes
Pause macro and resume when user clicks button
Hi I´m a newb in excel macros. I have a sheet where the users must define how many reports wants to pull by choosing from a ... -
0 Votes
Do Until Loop Counter
The macro I'm trying to create will probably contain a "DO UNTIL" LOOP that will: a) automate the F9 function, ie. ...Unanswered | 2 Replies | 1331 Views | Created by Guerchard - Wednesday, August 28, 2013 11:21 PM | Last reply by Guerchard - Saturday, August 31, 2013 12:06 AM -
2 Votes
Idea of a mini Project in Excel VBA
the students develop a macro to format a worksheet (i.e. column headers and column widths), and then loop through a simple lookup table to ...Answered | 2 Replies | 1600 Views | Created by Sakura Data - Tuesday, February 16, 2016 3:03 PM | Last reply by John - Project - Tuesday, February 16, 2016 3:37 PM -
0 Votes
change Properties of activex button in a macro
Excel 2016 vba - I have a sheet with 3 columns of activex buttons on it. They are not always lined up nice and neat. The buttons are not cell oriented so I want a macro to aligh all ...Unanswered | 1 Replies | 230 Views | Created by sp5db - Saturday, March 21, 2020 5:30 PM | Last reply by Hans Vogelaar MVP - Saturday, March 21, 2020 7:46 PM -
0 Votes
VBA Excel: How do I write a macro to delete rows when cells in column A have a certain value.
it. The macro needs to loop until the cell value is blank as there will be different numbers of cells with values in them in column A each time it is ...Answered | 2 Replies | 9132 Views | Created by Alan Millar - Friday, May 8, 2009 5:09 PM | Last reply by Alan Millar - Friday, May 8, 2009 5:38 PM -
0 Votes
Loop in an Excel grid
you want to accomplish. Anyway, a loop as you've shown is very slow. A much faster way is to use RANGE.FIND and search for a value in a column, ...Unanswered | 1 Replies | 235 Views | Created by Felix Guti - Thursday, December 28, 2017 3:31 PM | Last reply by Andreas Killer - Saturday, December 30, 2017 11:14 AM -
0 Votes
Infinite Loop problem
column B the value of column A + (1 up to counter). It should go until the the cell is empty. The problem with my code that the loop ...Unanswered | 1 Replies | 1756 Views | Created by albasel_2012 - Tuesday, June 19, 2012 7:12 AM | Last reply by Hans Vogelaar MVP - Tuesday, June 19, 2012 8:27 AM -
0 Votes
Excel VBA Query - Copying and Pasting Loop from Directory
against a wall for the last couple of days and would greatly appreciate someone's help. Basically (ha!) I'm trying to build a macro that ... -
0 Votes
Macro that hides rows based on a value runs very slow
I have a macro that hides rows if the value in column Q is = to 0. It covers rows 4 to 5,000. The macro takes forever to run. I ...Answered | 1 Replies | 285 Views | Created by RaysFan01 - Thursday, October 6, 2016 6:16 PM | Last reply by Asadulla Javed - Thursday, October 6, 2016 6:30 PM -
0 Votes
Loop Macro
Greetings. I have the following Macro which works. I just do not know how to "Loop" it. I really appreciate anyUnanswered | 1 Replies | 643 Views | Created by Wm H Long - Wednesday, August 21, 2013 2:38 PM | Last reply by Asadulla Javed - Thursday, August 22, 2013 6:46 AM -
0 Votes
Program or Macro to split large workbook by column value and into seperate files?
11.20.13 504.xls, etc. Is the best way to do this through a VB program wherein I can import the base file and it will run the loop or through ...Answered | 2 Replies | 863 Views | Created by Bnlmatt05 - Wednesday, November 20, 2013 9:02 PM | Last reply by ryguy72 - Saturday, November 23, 2013 5:17 AM -
0 Votes
Excel VBA: database connections, single login in
Hi all I'm a vb and excel noob, i am writing a vba function which a macro calls to output records from a database. the product codes are put into ...Answered | 1 Replies | 3616 Views | Created by Tweedledum - Thursday, January 15, 2009 10:52 AM | Last reply by Tweedledum - Monday, January 19, 2009 5:05 PM -
0 Votes
Loop Macro to Edit Date
Cross-posted at: http://www.msofficeforums.com/word-vba/19830-loop-macro-edit-date.html For crossAnswered | 1 Replies | 658 Views | Created by Damaniam - Wednesday, February 19, 2014 10:04 PM | Last reply by macropod - Wednesday, February 19, 2014 10:51 PM -
0 Votes
Result Set have few fields whose values are multi select Combo boxes. I need to edit Result set and update that particular field
combo box, I can change the value by multi select values from the combo box. I need to write a macro to do the same. Please ... -
0 Votes
Need help in using Macro to run Solver over multiple cells
> I've tried to run the Solver once for the first row (row 2), and recorded the Macro code as below. Please could someone help me with rewriting it as a ...Answered | 1 Replies | 3081 Views | Created by snoopyish - Tuesday, April 14, 2015 1:17 PM | Last reply by Edward8520 - Wednesday, April 15, 2015 8:22 AM - Items 1 to 20 of 2876676 Next ›
No announcements
