Search results for query: *

I'm having two problems with an Excel 2010 macro. I run the macro once a month, each time on a new set of data that contains a varying number of rows. It is supposed to remove a reference number from one cell in each row. (All of these cells are in the same column.) Unfortunately, rather than...

I'm trying to build a summary worksheet that will consist largely of rows of formulas that calculate minima, averages, maxima, and other results from data in other worksheets in the same workbook. I know the correct formulas. I know how to specify the range of data to be used within each...

I'm building a macro that will copy a table from one workbook to another. My problem is that when the code reaches the point where it's to switch back to the target workbook, I get a run-time error 424: "Object required." WHAT object? Here's the code: Sub Copy_In_Module_Totals() ' '...

I want to create a macro that will turn a block (rows and columns) of data into a table. Ought to be easy, except that the number of rows of data will vary from month to month, and I want the macro to deal with that on its own, so I don't have to define the table's size manually. This code will...

This ought to be really simple but I can't figure out how to do it. I want to create a macro that will check the (string) contents of the cells in one column, and based on the contents of each cell, enter a specific numerical value in the corresponding cell in a different row. The text strings...

It seems like this ought to be really easy. I’m trying to write a macro for Word 2010 that will find all words ending in –ly in a document and highlight them. The code below will find the first such word and highlight it, but stops there. The commented-out Do loop doesn’t end if it’s run. Sub...

It seems like this ought to be really easy. I’m trying to write a macro for Word 2010 that will find all words ending in –ly in a document and highlight them. The code below will find the first such word and highlight it, but stops there. The commented-out Do loop doesn’t end if it’s run. Sub...