I fixed my own problem, but it loops rather slow. If anyone has an idea to spped it up a bit I would greatly appreciate it. Here is the code I am using:
Sub Starts()
Dim rng As Range
Dim Cell As Range
Set rng = Range("C6:AD1505")
For Each Cell In rng
With Cell
If...
I have a spreadsheed that is pulling data from another worksheet, sorting it then using that data to fill in the cells on my report.
1. Column "a" is a project name and Column "b" of the is a start date.
2. Columns "c" through "ad" are weeks where
Row 2 contains dates for the begining of each...
I would cut the row and and insert above the row where you want it. For example, say you are working with rows 16, 17 and 18, and you want to put row 18 above 17.
Step 1) Select row 18 by clicking on the row number and "cut" it.
Step 2) Select row 17 and "Insert" "Cut Cells"
You can use the...
Got it...thanks to all. I just realized my initial range included the field headers and that was giving me the error. Once moved the start of the range from Z1 to Z2 everything worked out great!!
Thanks, but neither fix worked. The first fix I had already tried and received the same error. The second fix gave me a new error: "Reference is not valid".
I need a little assistance with a code that I am writing for one of my worksheets. Here is what I am trying to do:
1. loop through each row 1-200
2. If the cell in column "Z" is > 0 then
3. Goalseek the cell in column "AS" of the same row to 0.25 by changing the cell in column "X" of the same...
Skip you are an absolute genious. I will definitely give credit where credit is do. Looking at your logic, I can see what I was missing. Thank you so much for your help. You Rock!!!
The code range is in column A. The values for the code range will be S, O, E, F, EE and P. Colors are assigned to each of these codes.
The track range falls from Column G through column BB(one column per month for 4 years). The values for the track range are numeric.
When I enter/change a...
That didn't work...it colored some cells and blanked out ohers. It also took a while to run through the loop. I have no idea where to turn now.
Thanks for the help
Thanks Skip...that works fine for just row 18, but I am looking to run this through the entire worksheet so whenever I change the value in cloumn A the cells in the same row will change to the appropriate color if they contain values.
Example:
If I type s in A18 then the cells in G18:BB18 will...
Hi Everyone,
I have a major issue that I hope can be solved since I have spent about three days trying to figure this one out.
I have text in range1 ("A18:A300") but not in every cell. There are also numerical values in range2 ("G18:BB300") but not in every cell. As the values change in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.