range and macro

Hey all, I think this should be pretty straight forward, but I'm struggling a little. (I'm still learning VBA.) I'm trying to protect a workbook, but leave a few ranges available for co-workers to edit. I have the ranges set up so I can go to: Review Ribbon: Changes Group: Allow Users to...

Hi Everyone. I am a novice and this is my first post, but this site has solved many issue for me in the past. Anyway, onto my issue. I have a data file with 3 sections, and I'm doing calculations on the middle section. For the data that I want counted, I've been using code like this: With...

Hello everyone! Suppose I have the following range: <tbody> Project Name Color Project A yellow Project A green Project A red Project A green Project A green Project B blue Project B yellow Project B yellow Project B blue </tbody> I would like to code a custom function...

Hello everyone, I have an Excel workbook that has multiple sources of data that vary depending on the day. I am running into a problem with the equations refering the data giving me a #REF error when the number of data rows decreases. This is fairly easily corrected manually by selecting the...

The idea here is that I can pass the function a value and a range, and then it searches that range for the value, and returns the address of the cell in which the value appears. Function Find_Value_Location(FindString As String, Rng As Range) If Trim(FindString) <> "" Then...

Hello, I currently have a workbook with a tab named "Fill Form Fields", within that tab are multiple dynamic ranges (which are named) in columns of data that I have compiled into a data validation list in a cell on another tab named "iDiR Repairs" through the use of a macro. My problem is, if...

I was able to get help on this forum not to long ago on a solution that worked beautifully. However, I have tried to augment the number of routines. Essentially, what I am trying to do is run a series of sort & copy/paste to another sheet. The sorts are all well defined, but the copy/paste...

So I am trying to find the end of a column and input an if statment withing those 70 something cells. Below is my script any ideas?? FinalRow = Cells(Rows.Count, 2).End(xlUp).Row Range("A2" & FinalRow).Formula = "=if(F2="","", Today())" Range("A2").Copy Destination:=Range("A2" &...

Hi, and thank you in advance for your help. This is probably pretty simple for someone who knows what they are doing! I have 100 numbers, lets say A1:A100. I want to divide A1, A2, etc., by the sum of A1:A100 all the way down in the B column. For Example =A1/A$101$ (A101 being the Sum total of...

Hello Board, I am trying to figure out how I can change the following line of code to leave out the #N/A and just leave the cell values blank. I think that this would be an easy task but I can not figure it out. Range("DS8:DS78").FormulaArray = "=INDEX('Cover...

Hi All, I have a worksheet which has 4 columns. The first column contains name of person, The second column contains project code(the same code repeats for other persons as well), The third column has target values(This also repeats), The fourth column has total hours spent on that day. I...

Hi, How would you use cell reference for the following VBA code? Cells(10, 13).Select Selection.AutoFill Destination:=Range("M3:T3"), Type:=xlFillDefault Instead of "M3:T3" I'd rather use a cell reference or some kind of offsetting to drag a formula

Hello all, my worksheet has a named range that it constantly being resized; every week there's a new row added, etc. My goal is to traverse the array from top to bottom with checks at each row (VBA of course). An IF statement should check to see if CONDITION is met at each row. If it is...

Hi all, I am trying to put together an IF function that does something everytime a variable ranges between -5 and 5..I am however having an issue with the condition..how can I write the below correctly in VBA? If ActiveSheet.Cells(s,4).Value >=-5 And <=5 Then... Please help! Thank you...

Hi all- I'm trying to find/select the cell containing the minimum value in a range and I have two problems. First, my program does not recognize negative values. In other words, it will select a cell containing a zero value instead of selecting a cell containing a negative value. Second, if...

Hello, <TABLE style="WIDTH: 432pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=576><COLGROUP><COL style="WIDTH: 48pt" span=9 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent...

Hello I'm new to the board.... I am learning VB.... I have just inherited some charts.. which requires update fortnightly.... I have to copy A2:I2 with all the formulas, paste and shift down(done using macros). The chart will then be updated using A1:D28.... everytime the you add a new...

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...

Hello Mr Bill Hello to the forum! In VBA if i want to select the first row in selection or the last row or both : how to write the code, whatever the selection is : relative selection 9 different no of columns and different no of rows ) but with the same format : double border line in first...

Folks: Looking to modify your code to find the row with "Grand Total" in column B, then Range("A2:H" & LstRow).Copy I tried this code, it only copied 2 rows, definitely not the row with "Grand Total" found in it. How can I fix it? Thank you, Rowland: Sub try_this() 'copy...