lastrowcolumna

Hello, I currently have the following code to calculate howmany entries there are for each employee with in the date range (daterng2 &daterng3). I have now been asked to add an additional column which willbe cells(I,7) detailing how many unique months those entries fall under. Ie 01/01/2018...

Hi, i have been playing with various codes to get the Quarter of the date in column K, displayed in column P, here is my latest attempt, could someone tell me what i am doing wrong, have googled but not found any examples of what i am looking for. Sheets ("adviser data") Dim lastrowcolumnA As...

Hello, I am trying to get the following to work, if does not error , just returns blank cell rather than 0 or 1, can someone tell me where i am going wrong please. Dim lastrowcolumnA As Long lastrowcolumnA = Range("a" & Rows.Count).End(xlUp).row For i = 2 To lastrowcolumnA If Cells(i, 14) >= 2...

Hello, I have worked out the following code which is working fine, i have however been asked to add an additional criteria in, but to be honest i am not sure where to start. Dim Daterng As Long Dim Daterng1 As Long Daterng2 = Worksheets("Homepage").Range("k2") 'check date' Daterng3 =...

Hello Friends of Excel, I found this great formula on this forum that executes exactly what I need. https://www.mrexcel.com/forum/excel-questions/349567-formula-return-characters-cell-before-specific-character.html However, I try to appy this formula to a range of cells using VBA, I get a...