thisrow

Hi everyone, I was wondering if it's possible to create #This Row type table reference using a text stored in another cell - I have unsuccessfully tried a few things including INDIRECT but nothing worked. BACKGROUND: my spreadsheet has a manual input in the cell A1 and a formula stored in a...

I have to set the range on this macro before I run it. If it would only create the amount of cells needed to complete the macro. It works well and will give results to multiple sheets, sometimes I'm getting millions of results that exceeds the row limitations. If I set it to Const maximum =...

I've been working on this for days. I have lists of latitude longitude of 10 to 20 thousand entries. This results in 10's of millions of combinations....or more. Excel cannot handle much more than a million rows. I have been trying various methods which work as long as the result is within the...

Hi Everyone, I have this code that works great But instead of just working for column "CF" I'd like it to do the same but for "CF:CO" how can I get it to do this? Sub TestNames1() Lastrow = Sheets("Project Calendar Raw").Cells(Rows.Count, "A").End(xlUp).Row For thisRow = 2 To Lastrow...

Hi Please could somebody help with an issue I am currently experiencing? I have the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim thisrow As Long If Target.Column = 3 Then thisrow = Target.Row Range("B" & thisrow) = Range("B" & thisrow)...

So I do I set a template to have information look better? I have wrote a code that creates and renames worksheets based on my list. Each worksheet has Net operating income statements. Now I need these sheet look clean and with a common template. So how do I add a template on top of the code I...

Hello, I would like to ask for help with following code: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim thisRow As Long If Target.Column = 5 Then thisRow = Target.Row If thisRow > 3 Then Target.Offset(0, -1).FormulaR1C1 =...

Hi there: I tried to delete the whole row if the column contains certain words for example if a column contain "Labor Cost", I want to delete the entire row. The macro I have only can delete exact words that I put in but I would really like to delete both exact words and contain certain words...

Hi, very new to vba and this forum, which has been very helpful. I have some code that works perfectly but always gives a 'Run Time Error 13' and stops the macro from completing. Any help please? 'Delete a row of data Dim rngSrc As Range Dim NumRows As Integer Dim ThisRow As...

Hey guys- trying out conditional formatting on a table. there are about 20 columns. I want to apply simple formatting to the whole row based upon the value of 1 cell. I can do that for a single row. my conditional formatting rule looks like: =$H$30= "Closed" and currently it is applied...