selected cells

Hi All, I've created a button which prints a selected range of cells in the active sheet as below: Sub PrintSomeCells() Range("A1:D10").PrintOut End Sub I now want a button which prints the data associated with an entire drop down list but I also want it to only print the range for each of...

I have a workbook which contains worksheets that are sent out to employees for input. Each worksheet has an area of selected cells (B3:B5) which reference the name, department, and cost centre from a summary page. In previous versions of Excel, I could group all of the employee worksheets...

Does any one know the formula to calculate top half rows/ bottom half rows of column D, Simply by selecting ALL the rows in column D, as shown in the image (I am not looking for the =SUM formula ) i have several tables like this and sometimes the number of rows may be odd/even

Hi. I want to copy certain cells from a row and paste them in the corresponding row numbers, but in another column. For example, I want to copy cells A1, A7, A28, A2000 and paste them in D1, D7, D28, D2000. When I select cells A1, A7, A28, A2000 and paste them at D1, cells paste adjacently...

Good Day All New to the forum, but relatively competenent with the basics of Excel. I will be asking a lot of questions as I try to expand my knowledge, so i thank you all in advance. First one: A worksheet that acts as a personnel management whereabouts tool. I want to be able to selct a few...

Hi guys, Hoping someone out there can help me. Think it will be pretty easy but here goes. Trying to write a macro that will choose a selected range (E2:T200) on a secific worksheet (Edit) and delete the name range for that range without touching the rest of the workbook. Any help will be...

Hi there, in my workbook I have in sheet1 in selected cells links to a file called M11 PMO.xlsx. In sheet2 I also have selected cells (as in P6, P9, P12 and so on) with links to the same file. These are just links no formula in them. I could go to Data edit links, but that would valuerise...

I never liked the black print on very light gray interior for selected cells that is the default for Excel 2007. I found a cool procedure in an old post on this site to change the color of cells selected in a worksheet. I'd love to make this the default for all sheets and workbooks. Is there...