centre

I am creating a Menu program, with the opening sheet titled, 'MAIN MENU'. I would like to have this centred on the monitor and I can do this on mine simply by visually positioning the words. My problem is that I have no idea of the horizontal length of the user's monitor. Is there any way my...

Hi, I am currently working on a worksheet, and on the sheet there are 4 tabs which have the same layout but each is a different cost centre. I need to do a check to see if one number on a master tabappears on any of the 4 cost centre tabs. Basically I need a vlookup across the 4 tabs but in...

hi all this is probably really simple but all i have been ale to find is spit with commas etc. i have data that displays as below in column A <colgroup><col></colgroup><tbody> 102269 Robinson's Body Centre 102288 C & S Bodycare Ltd 102329 Cooper Norwich...

Hi First post so hopefully I can give enough information for someone to help me :) Im trying to set up a spreadsheet that will allow a colleague to enter information on the MASTER that will then feed into other sheets. The below a copy from the master sheet...… <tbody> <tbody> Date...

Hi all, Please could someone advise me what code I need in VBA to centre all cells (both horizontally and vertically) on an active worksheet? Cheers Chris

Hi there I need to save the file as a new workbook (asking user to choose path) and within that file, remove all formulas. The code I am using to remove all formulas is: Sub All_Cells_In_All_WorkSheets_1() Dim sh As Worksheet Sheets("ImportNonCCB").Visible = True...

Hi I've been looking at tutorials but can't quite get this to work.. I have a table with data set <colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody> CompanyID CompanyName Field Name Control Centre Position Field Source Country Code Country Name GDS 12345 ABC COMPANY...

Hello all. I require a little guidance on how to centre an image within 2 merged cells the code I have been using to centre an image in one cell does not work for 2 cells. No matter how I try I just cant get it to work. Is there a way to alter the code to allow for this. See bellow for the code...

Hi. I have a single, simple Excel sheet but I'm not sure how to present the data. To simplify, the data looks like ... CostCentre | TransactionDate | UserName | Cost | Cost Centre Owner abc1 | 01/01/18 | John.Smith| 0.72 | Jim.Jones abc2 | 02/01/18 | John.Smith | 0.13 | Cat.Smith abc3 |...

Hi guys.. So I am not sure how this can be but into a formular so I can get the wanted result on the right above in the table. On the left side there are more numbers and Letters to the left but they are not consisted or hang on.. there are numbers like FT12345678 or TT12345678910 if the...

Hi I have a massive VBA (eternally grateful to 'Fluff' and 'gallen') which does not centre data in the cells. I have tried recording a macro on a blank workbook and then copy/paste into my VBA. It still does not centre! The code (for this part) is: Range("A1:F500").Select...

How can I make sure that my userform (a) fills the screen, and (b) is in the centre?

Hi Guys Can someone please urgently help. Why this code isnt pasting in another workbook. it doesnt show any error, but doesnt post either. (pasting code is the fourth line from bottom). Thanks so much Sub SplitData() Const NameCol = "c" Const HeaderRow = 1 Const HeaderRow2...

Hi guys, Yesterday i had a job to make a vba to pagination. That was the working results. Sub sheetcounter() For i = 2 To Sheets.Count Sheets(i).Select Application.PrintCommunication = False With ActiveSheet.PageSetup .RightHeader = "&B &Kpch&J" & ActiveSheet.Index - 1 & "\" &...

Is it possible to add the 'centre across selection' function to the ribbon? I use it a lot and it's quite fussy to get to. thanks! its excel 2007. thanks

Hi, I am using the below macro to insert images into a group of merged cells, it works perfectly however i would also like it to automatically scale and centre the image to fit in the merged cells... Any ideas ? Thanks in advance Alex Sub InsertImageBox1() Dim FName$ With...