font-family

I was looking for help on creating some code to find sets of numbers. I can’t use a formula because their is problems with other VBA code I run in the same cell range when I do that. The code would search for any set of numbers (1-1, 9-9, 20-1 etc.) in the ranges E3:E25, F10:F45, H3:H20 (I...

<code class="western">I have one line in my code that deletes the data in the first cell to the right of a found search in a specified range. I would like to increase that ClearContents from 1 cell to 3 cells and I just can’t seem to find what that code is.</code> <code class="western">...

Hi I have code that I would like to make a small change to but need some help with. I only need the first cell in all the ranges in all the “arr1” in my code below to be increased by one row , so the 1st change is the current range is Range("D22:I36") change to Range("E22:I36"). I can do...

Hi, first post. I was wondering if I could get help on developing a macro that would add dollar amounts in a range. I’ve looked at formulas but that will not work in this case. In my research i found the following: Conditional Logic in VBA In the most of programming specific sections of...

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Georgia, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-family...

I have a macro that I’m looking to make a small change to what cells get deleted after a copy and paste takes place. If someone could kindly assist. What I need to happen is as follows: Once a found number is entered in cell A1 (8 in this case) and is found in the cell range A20:A34 (cell B34)...

Hi This is my first post. I’m trying to set up a macro that uses Solver and I have some code below. I was wondering if someone could take a look to see if I’m on the right track. This is what the macro should be doing: Numbers will always be present in one or all of the...

Hi I’m using the following formula but would like to change it to include more than one result: =IF(ISERROR(LOOKUP(2,1/(E36:E52<>""),E25:E50)),"",LOOKUP(2,1/(E25:E50<>""),E25:E50)) If for example the existing formula was placed in cell B5 but an additional two results could be...

Hi I have the following VBA program that works but I would like to make two changes and just not having any luck. The first change is to have the existing "1-1" accept any number combination (say 1-99 or 99-1) right now it only accepts 1-1 as a positive result. My second request is to the have...

I'm been trying to find out what wrong with my code (In sht.Range....) but I don't see it. Can anyone help me? Thanks so much <code class="western"> ‘</code><code class="western">Move the cell contents to the next cell</code><code class="western"> </code> <code class="western">...

I’m using a program that I’m trying to add to. I need to move the contents down one cell but I’m not sure how does the program move contents down from one cell to the next if the next cell is full without overwriting it and then move that one down. I’ve included a jpeg of my excel sheet. I hope...

Hi I’m a newbie to Excel and have spent many hours with no luck on this one. Using actual cell locations here is the project: 1) In cell C17 I enter one number, can any number from 1 to 10. Lets say I choose the number 4 as an example. 2) I have 5 locations where number 4 could be...

Hi All I found the following formula which almost gives the results I require:- <style>table { }.font5 { color: black; font-size: 9pt; font-weight: 700; font-style: normal; text-decoration: none; font-family: Arial, serif; }.font6 { color: black; font-size: 9pt; font-weight: 400...

Given data prepared as in the attached spreadsheet Given a sheeet with Column A of values (say names) with corresponding columns B, C, D, etc. containing values relevant to row A, how would you created additional rows for the names in Column A, 1 each for each value in columns B, C, D, etc...