So I am trying to have a bit of code that recognizes all values between 3 and 5 within a range (which I will refer to as n) and if a cell value falls within this range then apply the replace the value with the following formula (n[original val] - 3) x .5) +3
Below is the code I have...
I need to copy and paste the values of certain columns from one workbook to different columns in another workbook. See my code below..
I know this code is not efficient, I am new to VBA and would appreciate any help to make my macro more efficient..
I could start copying from row 2 instead...
I have 2 ranges (each with headers and underlying text data) stacked on top of one another on the same worksheet. I am attempting to write a macro that autofilters the first range, copies and pastes data I need from each column to a separate worksheet, and then moves down to the second range...
I have a list of sells that is poviding, for simiplicity sake, the Following
Col A - Company Name
Col B = Start of year (e.g. 1/1/2007 or 1/1/208)
Col C = End of Year (e.g. 12/31/2007 or 12/31/2008)
Col D = Revenue for the year
This goes on for a good 1500 rows. What I am trying to do is...
I'm probably being really stupid but I can't figure this out.
So, I have a string variable that I have being input through an Input box, this variable is
Dim VP as string
This is carried through to a private function where I want to add this into a formula. The formula is a simple one...
I'm writing a macro to apply some simple functions (copy, paste, sort, etc) to a sheet of data. My problem is that the number of rows in this sheet will vary for each occassion I want to apply the macro. Can someone please tell me how to instruct a function to first calculate the number of...