borders

I need to write a general function to set a border around each printed page, given a set of page breaks. The user will set his/her own print areas, and then the macro is required to format a border around these edges (exactly where the blue lines appear in page break preview. How do I access...

Hi, I have an Excel 2010 spreadsheet with borders around selected cells, the spreadsheet is protected so my formulas can't get corrupted, but with some cells that are unlocked for user data entry. But when you copy and paste in these user entry cells the borders are getting copied and...

Hello guys I am trying to right a macro that will compare different ranges with each other. Each range is enclosed by borders, so I would like the macro to compare what is within the borders to the next range. Essentially I am comparing the same functions from three different projects to see...

The F column has this following code: =IF(ISERROR(VLOOKUP(A7,Beers,2,FALSE)),"",IF(VLOOKUP(A7,Beers,2,FALSE)=0,"",VLOOKUP(A7,Beers,2,FALSE))) I need a VBA script that only creates a border around those cells that evaulate to a value and not "" This is the code I've tried: Dim LastRating...

Hello again folks Im working on a large comparison spreadsheet, hence the questions all of a sudden. Now I am trying to write a macro to draw a border on the right edge of the furthest cell that contains a value in the whole sheet. Essentially I am trying to get the macro to look from column IV...

Hi guys So I have a macro which imports a text file to excel. The text files are made up of individual tables that each end with the word "END" What I am now trying to do is get another macro running that detects every instance of "END" and then puts a continuous border along the bottom of...

Hi all! I am currently working on an Excel file that could be considered a work of art. I am sure we have all found ourselves in a position where you look at your work and say, "Hey!, who said these spreadsheets can't be fashionable!?" Having said that, I would like to create a visual effect...

In earlier versions of Excel, I would create a table in Excel and then copy/paste into PowerPoint. Once in PowerPoint, I would reformat, retype, edit, and then place boxes over the text to format, etc. However, in Excel 2010, when I copy a table and paste it into PowerPoint, slightly colored...

Hi all, I have a database and a few hidden columns and right now i'm using vba to insert new records via a userform. Whenever a new record is inserted via the userform i use codes to draw the borders. However, the hidden columns doesn't have the borders drawn when i unhide the columns. Any...

Hi All, I have a table that has thin borders around all four sides of the cells in a column. My column is in the middle of the table and I have to delete the columns so that now this column is the last column in the table. After I delete the columns to the right I lose the borders on the right...

Hi all - I'm trying to sort an Excel 2003 workbook where some of the cells are highlighted and a few have single cell borders. The sorts are simple alpha or numeric ASC or DESC - nothing fancy. Sometimes the highlighted cells move with the data during the sort but othertimes the data move and...

i have 2 cells that i cannot change ( add right border ) to the cells. i have tried deleting all border and reapplying. same result. <input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

Hello, The borders of my spreadsheet are too thick. Is it possible to create borders with a thickness (width) smaller than the smallest option available? MS Word, for example, has a line thickness as small as 1/4pt. It seems to be 2 whole options lower than the lowest option on Excel...

Hi, I have a table listing projects a company has done at certain cities. Within one city there might have been several projects, so I have merged and center the cells under the city column for these projects into one. Like this: Chicago__| P1 _________| P2 _________| P3 Those...

I have a multi tab spreadsheet, with borders for boxes on several pages. In 2003 I can print each page showing the borders allowing manual ticking as a printed check box. Opening this file in 2007, the borders print fine on some tabs, and on others do not print at all. I'm using the same...

hello, i'd like to format a cell based on the values of 3 cells altogether. explanation: i have a sheet arranged in such a way that two tables can fit on a page (when printed). columns A and F have names of items, columns B and G are numeric values, columns C and H contain dates, while column...

Aloha... our office recently "upgraded" to Vista, including moving from MS Office 2003 to 2007. This code, which simply formats two ranges with various border and font settings, stopped working. Specifically, when trying to set the border weights for the range "rngHoriz", they all give the...

Hi, I am trying to write vba code that will highlight the row in the range if a field is over a certain percent. The column number won't change but the number of rows will. I'd also like the code to automatically work on all tabs of the workbook when a button is clicked. Data Info: Currently...

Hi Folks, Is the a single line of code that I can use to remove borders from the entire worksheet? Thanks for the help...

hello ;) i want to apply this code that i recorded to columns "A","B" and "C" and to unknown number of rows, here's the code: Sub Macro1() ' ' Macro1 Macro ' Macro enregistrée le 04/03/2009 par MehBA ' ' Selection.Borders(xlDiagonalDown).LineStyle = xlNone...