range and macro

  1. S

    Macro to Protect All except a few Ranges

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

    Using VBA Array Formula without R1C1 notation?

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

    Heavy custom function

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

    VBA AutoFill Varying Rows of Data

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

    type mismatch on passing a range value

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

    Data Validation with Multiple Dynamic Ranges with VBA - Macro to Auto-Update

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

    VBA Copy and Paste Isn't Working with Additional Sort Filters

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

    What am I Doing Wrong??

    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" &...
  9. A

    VBA Macro Divide a Range of Cells by a Constant Cell (different constant cell location per spreadsheet)

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

    Help to change VBA Array Index Formula to remove #N/A leave blank

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

    sum the values based on three columns

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

    Drag formula using VBA

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

    Named Range Manipulation

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

    If condition with range

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

    Application.min doesn't recognize negative numbers or percents

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

    MacroProblem: Highlight (color) Rows that Meet Criteria from a List

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

    Dynamic Chart

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

    Define a variable range, analyze and produce two results

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

    VBA Selection Code

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

    vba Found text cell address as last row range row

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top