short cut

Hey all! I was curious if there was any way to shorten this code. I want to be able to look at three columns (TYPE1, TYPE2, etc.) and essentially, in a "rank" order, have the value in the original cell be the one that first is shown in the column. Here is what I am working with so far (and...

While doing some VBA debugging and performance testing, I have been using the ALT-LPMR to run the first macro which measures the performance of my sheet. Note that developer tab must be enabled. I like to hold the ALT key down the whole time. If I do this, then my old slow computer beeps. I...

Hi Guys!, Can i get some help from you all and know some excel shortcut for my formula? This following is my formula: so basically what i want is that if the value of cell L2 is =s to any cell of column D (eg, L2 = D15) then it would be equals to the row of D but column of H Thank you all very...

Hi, Does anyone know a short cut to the following - I have a formula that references a cell on another tab I want to quickly copy this, but the tab im copying from goes along columns and on the main tab it goes rows. Is there a quick way of dragging like when you normally do it? For example...

<TABLE style="BORDER-BOTTOM: rgb(228,237,246) 1px solid; BORDER-LEFT: rgb(228,237,246) 1px solid; WIDTH: 98%; BORDER-TOP: rgb(228,237,246) 1px solid; BORDER-RIGHT: rgb(228,237,246) 1px solid" cellSpacing=0 align=center><TBODY><TR><TD> </TD></TR><TR><TD></TD></TR><TR><TD...