variable content

Hi all; new user here. wondering if anyone can help with a doozy of a problem. I'm trying to use a drawing object to select a range of cells. and/or values within these cells. much more valuable if an irregular (polygon) shape can be utilized. For example; I have a table, and chemical...

Hi All, I am having a problem with getting a specific Macro to run when the text in a cell is changed to a corresponding value. What I would like is for a Macro to be ran on one worksheet (Report) when the value of a cell (A1) on another worksheet (CaseSelect) is changed. The value of the...

I need to remove the letter within the middle of a persons name. For example, if the person is called 'Michael J Fox' then it needs to be edited to show only 'Michael Fox', if the person is called 'George W Bush' then only 'George Bush' should be displayed etc. However the persons name should...

I need a way to calculate commission for my sales reps. The commission is based off a calculated value in H39 of a sheet that I have developed. They get 7.5% of the value when between $1 - $100,000, example: sales of $50,000 = $3,750 in commission. If the value in H39 is > $100,000 but...

Hi Folks I am trying to work out how to get column/ row values from an address string. the relevant code I am using is:- DivCell = Cells(DivRow, DivCol).Address EndCell = Cells(ExpRow, ColMax).Address If Not Intersect(Target, Range(DivCell, EndCell)) Is Nothing Then...

Hello All, I have a macro that copies a range that is set, then pastes these values at the bottom of a table. This would be ok but even if the copied area does not have values, it expands my table with empty rows. The next time this macro is used it paste the new information under the...

I'd appreciate some help with this problem, I'm brand new to Macros, but pretty godd with formulas, however this thing has got me flummoxed! Here's a sample my data: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=640><COLGROUP><COL...

Hi VBA Gurus, I need some help with a VBA transpose function. The number of rows to transpose varies .. but the common marker is "Exited Site".. Would ideally like to see the results in a new sheet here's what the current (input) data looks like .... <TABLE style="WIDTH: 132pt...

Hi all, I've got some code that calls a public variable. If I run the code a second or subsequent times it fails I have the public variable set Public FileName As String in module6 The information set in the variable is gained from this bit of code Sub ImportTextFile() Sheets("Raw...

I have a macro that I use daily, however the data that pulls back is not consistently in the same rows, so the formatting needs to be fixed daily. Is there a way in VBA to use variable rows depending on what's filtered? Here's part of my formatting code: Sub HyperionTeamsC()...

Hey all, I've been working on our headcount templates for our planning process and I'm trying to find a way to extract the data from all of the responses into a single worksheet that can then be imported into Access. It's highly manual and did a simple macro but it didn't capture everything...

Hi all Is it possible to have a variable within an excel formula; Example: I have values in cell A1=100, A2=200 and A3=300 In cell B1 I will state which of the cells in column A I want to use and multiply by 5 I could look like this: Cell B1 = A2 Formula; =B1*5 should equal 1000 If I...

I am trying to create a macro that will fill out documents in Word 2003 (or Word 2007). I can do this for static documents, but am having trouble with variable documents. What I mean by this is, my comprehensive template has 61 sections, but for any one case, only 20-30 of them are...