excel range

Hi, The code below allows me to add zeros to a specific row. I am trying to change the code to reference a particular cell value where I specify the range I want to use, but I am getting the Object Required 424 Error. I have added both lines of code the one that works well and the one that...

Dear Members, I would like to use VBA to identify contiguous cells having similar formula (which we create using fill down or fill right in excel by dragging the mouse). I have below table as an illustration. The range having similar formula here is C3:C7. <tbody> A B C 2 Age Weight...

Hello I would really like to understand what determines the use of these two bits of code. This works fine: <colgroup><col></colgroup><tbody> wbTSS.Sheets("Sheet1").Range("D2:D" & LastRow).FormulaR1C1 = _ "=IF(RC[1]="""","""",VLOOKUP(RC[1],'[Dundee Assay building.xlsx]Kinase...

Set xlbook = GetObject("C:\07509\LB_RACKTMC.xlsx") Set xlSheet = xlbook.Sheets("LB RACK") Set src = xlSheet.Range("f1..f3").CurrentRegion.SpecialCells(xlCellTypeVisible) Set sh = xlbook.Sheets.Add src.Copy sh.Range("a1") m = sh.Range("a1").CurrentRegion For ro = LBound(m) + 1...

Hi , i am having an problem setting the value of a cell in a range. i have a simple test document in which i am using 3 columns F, G and H. Column F is a dropdown list with 3 options "rate1, rate2 and no rate". Column G is column which is data validated to take except whole number between 0 and...

Hello people! I have the following piece of code, that gets error 400: public sub TestMe Dim range_for_analysis As Range 'tbl_master.Activate Set range_for_analysis = tbl_master.Range(Cells(current_row, STARTING_FROM_COLUMN), Cells(current_row, calendar_cols + COLUMNS_NOT_TOUCHED))...