Hot answers tagged

2

No offence dude but worst phrased question ever! Also, formatting! TL;DR, here's what I think you need Put this in C4, it will translate the A to D into the sheet name. =CHOOSE(CODE(B4)-CODE("A")+1,"Alpha!","Bravo!","Charlie!","Delta!") Now in D4 we will calculate the index or row number in your chosen sheet ...


1

To prevent the code from stopping after the first blank cell is found, you need to remove Exit Sub. You need to have a counter that will be incremented after a blank cell is found and the message written on a cell on the report sheet (in my code below, the report sheet is Sheet3). Your code will look like the below. i is the counter. I have removed the ...


1

Is there a space between the 8 and the hyphen? Always, sometimes, never? That would throw off your formula. More generally, I think you have overcomplicated this by using LEN. Your FIND already shows the position of the hyphen from the start of the string, which indicates the length of the text/number before it. So something like =FIND("-",B2)=9 ...


1

Adapt the code below. It gets the last non-blank cells in row 1 (assuming the contents of the row are headers). This allows to get the last column. Then loop through each column and row (if necessary). Sub Loop_Column_Row() Dim lRow, lCol As Long 'Find the last non-blank cell in row 1 'This assumes that the first row has column headers ...


1

The built in Word "find and replace" tool can do 90% of the work for you. It can search on page breaks, paragraph marks, spaces and so on if you use the "More >>" option where a "Special" drop down button lives. That "Special" button will allow you to select paragraphs, various different whitespace characters, ...


1

Need to Update VBA DateToday= Format(Date, Number) Set pivot filter cell format as Number If the Pivot sheet Activated then the Date automatically filtered itself . @Mobus Thanks....


Only top voted, non community-wiki answers of a minimum length are eligible