implement

Hello, This may or may not be a simple porcess as I am very new to coding for macros. I have 3 processes I want to implement into my excel. First, I want to change my current highlighting process for columns I & J. They are highlighted green for all non-blank-cells. I wish to highlight them...

Hi all, Can someone assist me on the below. > I need to filter the data in column B apart from blanks and delete the entire row. > If no data found while filtering then i need to release the filters and move on to the next subroutine. Please assist me that how to implement If condition in...

Tell me, are there any formulas that can implement this?

Hi all, Please assist on the below. I need to implement the following formulas in the entire column AL (Used range) and the formula is =IF(AND((AK2>=5),(AK2<=10)),"Between 5 & 10 Days",IF(AND((AK2>=10),(AK2<=15)),"Between 11 & 15 Days",IF((AK2)<5,"Less than 5 Days",IF((AK2)>15,"More than 15...

Hello, I have a macro that might refer to nonexisting sheets. I want the macro to, let's say, select the A1 Cell on the sheet a if an error occurs. How do I implement this with On Error Go To?

Hi, I recall seeing this on YouTube videos. Basically if the cell is highlighted it has a "bold" or "distinct shape" around it so that the cell is easy to identify. Is there a setting in excel to implement this? I am using excel 2010. Thanks

I have this little line of code: Selection.Offset(-1, 0).Select Now the -1 here needs to be variable, it could be either -1 or -2. I have a cell whose value determines that. How do I implement that into the code?

Hi All, I have a rather big vba project that is used by multiple users. The different worksheets and userforms all have a uniform look and feel. Used colors are defined by RGB values. In my current code, the used colors are hard coded. For instance, the background of each userform is set...

Dear Excel community, Suppose I have a spreadsheet containing data looking like this table below, 5/10/2017 Column B Column C Column D Oct-17 Nov-17 Dec-17 1 1 Jan-18 Feb-18 Mar-18 2 2 Apr-18 May-18 Jun-18 3 3 Jul-18 Aug-18 Sep-18 4 4 Oct-18 Nov-18 Dec-18...

I'm trying to do something like calculate(sum([amt]),[s]<>a||dimension[doc]<>b)). It seems so straight forward, but then maybe I need a fake dimension table for the fact column I'm filtering on. Before I implement a dumb solution like that, I thought I'd ask to see if maybe my syntax is just...