Jun 7, 2017 - Example. This example clears formulas and values from cells A1:G37 on Sheet1, but leaves the cell formatting and conditional formatting intact.

I have a macro that copies data (integers) produced by formulas and inputs them into my Range of AE8:AE31. The quantity of numbers can vary in each column. How can I create a macro to go to the first blank cell in my range and clear the contents. Example Data: AE8=1 AE9=6 AE10=7 AF8=1 AF9=2 AF10=6 AF11=8 AG8=1 AG9=2 AG10=4 AG11=5 AG12=6 In the above example:- Go to AE11 and clear contents from AE11:AE31 Go to AF12 and clear contents from AF12:AF31 Go to AG13 and clear contents from AG13:AG31 Thankyou.

Hi, I'm not totally clear on what you want. How do you determine where the end of the data is in each column? Does your data look like this?

Hi Dan, Thanks for your reply. I've downloaded the HTML add-in but I don't know how to use it yet. Xbox driver for mac. My problem is driving me crazy.I've been on it for days. The frustrating part is that if I break my code up and run in two parts separately, the whole thing works BUT only if I enter part A's output manually. Where is audio transition breeze in powerpoint for mac.

If I let the code pick up the output from part A, the results are corrupted. I've assumed it's because I'm picking up data from blank cells, hence my post, but maybe I'm wrong. Perhaps if I go back to the start and give you all my details you may have a look at it and see where the code is breaking down. My Problem: Enter a column of numbers. Range is B8:B31. In columns C8:E31, select a mixture of those numbers using tick boxes. The numbers will be random initially but part A of the code puts them together in ascending order.

Use code to work out all the permutations of those selected numbers and output them to Range G9:I100+. (generally won't be more than 100). Exclude combinations of the same number in the output range. No blanks i.e. 1 blank 4 or 1,1,4 are invalid. Solution: Below is the code in two sections. The first copies the ticked selections and sorts them in ascending order and outputs them to AE8:AG8 down.

They are all integers by the way. The next part of the code computes all possible combinations and outputs the result in range G9:I9 down. The part not working. Part 2 of the code BUT. If I manually overwrite all the numbers generated by part A in the range AE8:AG8 down and then clear the contents of all the non visible cells (they appear blank) in these 3 rows down to row 31 and then run part B of the code, it runs perfectly and computes all permutations correctly.

Must be something obvious in the code I am overlooking. Can you help me resolve this please Dan. I'm totally frustrated. B8:B31 contains integers. This is the formula in C8 copied down.

=IF(AND(AB8=TRUE,B8'),B8,') This is the formula in D8 copied down. =IF(AND(AC8=TRUE,B8'),B8,') This is the formula in E8 copied down.

Excel macros save you time and headaches. And you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one.

With Excel 2013, it’s as simple as recording your keystrokes. Use these tips to make macro recording a cinch. Further Excel training If you want to deepen your Excel mastery, a number of online courses exist to expand your knowledge.

Here are our top picks to start with: Coursera - EDX - Lynda.com - Udacity - 1. Macro names Keep macro names short (but descriptive), especially if you record a lot of macros, so you can easily identify them in the Macro Dialog Box. The system also provides a field for Description, though not everyone uses it. Macro names must begin with a letter and cannot contain spaces, symbols, or punctuation marks. After the first letter, you can use more letters, numbers, or the underscore character, but the maximum length is 80 characters.

Use relative (not absolute) cell addresses Absolute means that the exact cell locations are recorded into the macro—hardcoded cell addresses such as A6 or B12, which limits the macro’s ability to function if anything changes, new data is added/removed, or the list gets longer. Relative means the macro’s recorded keystrokes are relative to the starting cell’s location. The default in Excel is Absolute, but you can change this to Relative on the Stop Recording toolbar: Click Developer> Record Macro. • In the Record Macro dialog box, enter a macro name and Shortcut Key (if applicable). Choose Personal Macro Workbook in the Store Macro In box, enter a description (if desired), and click OK.