area

Hello friends, I am new to mrexcel massage board. So accept apologies If I couldn't fully describe my problem in the way you all do. If we make a chart (xy scatter) with two data serious. On on top and other below, or even maybe crossing each other. Can we calculate the bounding area between...

Hello! I am relatively new to Macros so bare with me. Here is the code that I am working with: Sub Step4() ' ' Step4 Macro ' ' Keyboard Shortcut: Ctrl+Shift+N ' ActiveSheet.AutoFilterMode = False Range("K1").AutoFilter Field:=11, Criteria1:=Array( _ "#N/A")...

I am using code to apply basic borders around all used cells in a worksheet. Perfectly, this applies borders to the anticipated range. I use the same range to set the print area. I'd like to modify the macro to modify this range so as to set the print area AND apply borders to all cells...

Hi! I am trying to determine the "white space" between the last used row and the last row in print area. I currently have this to determine last used row and it works, but can't determine last row in print area. Sub cover() Dim lastrow as long Dim top as string Lastrow = range("A" &...

Hi, Is it possible to rename the active sheet shapes with cell values, there will only ever be 15 shapes in column C and 15 cell values to use as a name in Column B cells B2,13,24,35,46,57,68,79,90,101,112,123,134,145,156 - Each cell has a different name and will always be a number. Both...

hi kings I would display the numbers filtered in this area of the text I want when I filter each number is displayed in this area ( see the picture ) thanks you all i love

I'm trying to figure out how to use VBA to center or reposition the axis (x and y) labels based on the height and width of a chart's inner plot area. Any help or input would be greatly appreciated!

Hello :grin: New forum member here and a novice/ intermediate at Excel. Could use some help as I'm not able to get through this on my own. So presumably I got a data validation list in the first column with Yes/No. When the user chooses the option yes I want the actions and costs column to...

Hi, I have a macro already setup to do most of the tasks, but what I need to is be able to select the area from cells D1:M1 down to the bottom of my data, which changes every day, it could be 100 rows down or possibly 300rows. Is there a way to do this for themacro? To select the varying data...

Hi all, Long time reader/lurker, but a first time poster here. I have developed a dashboard within Excel 2016 to bring together Customer Feedback data from 3 different sources (at present - longer term will add more to the mix), and used Power Pivot to help with this as contrast and comparison...

I have a pivot table which counts the number of records per category. I would like to filter it so it only counts records that are older than 100 days. I added a filter to the pivot table area for the age of the record but to filter I have to check each box for any value over 100 and that is...

Hello All, I have this code very close to what I need it to do but I think I need to add a counter of some sort. I'll try to explain this AS BEST AS POSSIBLE. I need this code to count how many times there is an occurrence of an Alphanumeric value in Column C and then simply increment the...

Hello all, I have a code below that copies the contents in columns A, B and C to the next blank row. I also need this code to Duplicate/Rename the contents in Cell C with, preferably REV 1 after it. Basically here is the format the users will be putting in Column C: LEVEL 1/ AREA A/ RM 125 I...

Hello, I have a problem with function: I would like to sum area form row 11 till 54 but with hlookup. But the problem is that the number of rows will grow so I don;t want to write every row in brackets. i thought of index but the second problem is that the summing are is always one column...

Hi I have a table on one sheet with a few columns, including COUNTRY, AREA, ROLE and COST On another sheet I have the same columns where people can select the country, area, role from a drop down The sheet with the predetermined area is called called "CTC", some example cells: C7 = USA D7 =...

Hi all, Very new to all this - I'm an old dog trying to learn new tricks. I have created a userform with textbox's and combobox's along with a save button. When you press the save button, all the entered data does what it is meant to do - sent to sheet3 (info) and then resets the form for the...

<tbody> Name Area 1 Area 2 Area 3 Area 4 Area 5 Area 6 Area 7 Area 8 John Y N Y Y N N N N Brad Y N N Y Y N N N Nate N N N Y Y N N N Luke N Y N N N N N N Mark Y N N N N N N N </tbody> Hello, I am looking to drag down dynamic...

I have two spreadsheets in one file that are identical. In one spreadsheet I highlighted an area and named it "abc". I created a macro in this spreadsheet to print area "abc" to my printer and called it "printabc". In my second spreadsheet in the same file I highlighted a similar area and...

Running 2016 Pro Plus. Have a large (about 110,000) row table that has also been loaded into the Data Model (no relationships established). Creating several Pivot Tables from the Data Model. Assumed that a separate PT cache was established for each PT. Created Slicers for each PT (using the...

hello, I have some data in 4 cells and i need their unique value in a single cell in below format. <tbody> CITY ZIP AREA CODE UNIC NAME MUMBAI 853024 2019 MBHA MU_19_BH_24 </tbody> Thanks