Set Blank Columns To Be Certain Width?

Sep 4, 2012

How can i make blank columns be certain width using VBA... I need to do this because the data that is populated in a sheet will be different every time i need the blank columns to be certain width.

View 2 Replies


How To Adjust Width Of Columns Faster

Nov 17, 2012

1. Is there a faster way to adjust the size of the columns? I had to use my mouse to stretch the column out. This can be quiet time consuming if there are 8 columns needing to adjust to the same size. ie Col A, B,I, J needs to be the same size.

2. Can Excel determine the best size for the column? Say I need a column with data saying "yes" and "no" and a column for the letter "X" only or do I have to stretch the width of the column myself?

View 1 Replies View Related

How To Make Excel Report Width Of Columns(s)?

Jan 13, 2010

I'm looking for a macro or function/formula to list & total a range of column widths. Having lots of columns with varying widths t'would rather not have to do it manually from each column's Properties.

View 9 Replies View Related

Columns Appear To Be Hidden But Will Not Respond To Unhide Or Width Change

Oct 6, 2013

I have just been sent a strange file, which I have attached, on its only sheet columns "A" and "B" have data entered in them, but they are not visible. You can access them if you select column "C" and use the left arrow key, but all attempts at unhiding and changing the column width are fuitless.

I have tried selecting the ENTIRE sheet, then Home>Format>Unhide Columns but it does nothing I try selecting the entire sheet, then Home>Format>Column Width and setting it to something, like "20", but again it is fruitless.

I even tried using a macro in the "Immediate Window" to ask Excel whether the columns are hidden (by using "?Columns(1).Hidden" and it returned "False") then I used a similar macro ("Cells.EntireColumn.ColumnWidth = 12.75") and again - nothing! :O

View 3 Replies View Related

Loop To Increment Column Width Of Range Of Columns?

May 22, 2014

I'm trying to use the following loop to increment the column width of a range of columns thus:

NewWidth = 0
WidthIncrement = 0.5
For MyCount = 1 To 26
NewWidth = NewWidth + WidthIncrement
Cells(1, MyCount).EntireColumn.ColumnWidth = NewWidth

If I set WidthIncrement to be an integer value, the code works correctly. If, however, I make it something like 0.1, all the column widths that the loop acts on are set to 0. I suspect it's something to do with how I'm declaring the NewWidth and WidthIncrement variables - they're currently set to Double. I know that I can have decimal values for column widths (e.g. 8.43)

View 5 Replies View Related

Text To Columns Macro (fixed Width) With Predefined Format On Result

May 18, 2009

I need to fixed width-text to column macro and found a reply in the forum.

However, when I apply the macro, the result of zeros in front of figures disappear since the format of value in splitted column doesn't predefined as text

e.g. sample text to split to column:

Required result:

when running below macro; result shows:
(Beginning zeros figures of the first and last column disappear)

Applied Macro:

View 3 Replies View Related

Adjust Cells Column Width Without Whole Column Width Changing?

May 24, 2012

Is it possible to adjust a cells' column width without the whole column width changing? EXAMPLE...I'm looking to lock rows 1-41 at certain column widths and change the column width as needed from rows 42 and below.

View 4 Replies View Related

Filtering Columns When Adjacent Columns Are Blank

Apr 15, 2013

I import a text file that displays outstanding parts orders. The order Number column only displays one number even if there are multiple parts ordered I.E. so if three parts are on order then the order number is displayed once with the other two underneath blank. I would like to filter the column that displays the amount of stock that is available so that even if the row has no stock but the other two have all three rows are displayed that reference the order number.

Example Screen


View 5 Replies View Related

If Sum Of Columns Is Blank Show Another Value

Sep 10, 2009

I attach a file for you to more easily understand my problem. I have a big table with information, then I would like to summarize this, if all fields for certain "Type" (see file) is blank, then I would like to use another value that I keep as a separate row in the summarize table. But I also need to have it to work if zeros are put in, I need to show that value, that's my biggest problem right now when using sumif forumla.

View 5 Replies View Related

CountIf Blank With Two Columns

Feb 25, 2010

counting cells if blank. I have two columns E and J . For example if E5 and J5 are both blank I want that to count as 1.

View 13 Replies View Related

How To Count Non-blank Columns

May 11, 2012

In a single cell I want to return the number of columns in a matrix which contain entries. So, for the matrices below the formula should return '2' (two columns contain values):

A1: 0 , B1: 0, C1: 1
A2: 1 , B2: 0, C2: 1
A3: 0 , B3: 0, C3: 1

A1: d, B1: e, C1: 0
A2: 0, B2: f, C2: 0
A3: 0, B3: g, C3: 0

View 3 Replies View Related

Hide Two Columns If One Is Blank

Mar 25, 2009

Currently using this code to search Column D and hide if the cells are blank. How would I go about also hiding Column C as well, If D is blank?

I am using the spreadsheet as a grading template. The assignment name is under column C and the grade under column D. If there is no grade then I would like to be able to hide the unused assignment column along with the empty grade column.

Sub HideColumnsInd()
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
Dim rCell As Range
For Each rCell In Range("D3:D48")
If rCell = "" Then
rCell.EntireColumn.Hidden = True
rCell.EntireColumn.Hidden = False
End If
Next rCell
Application.EnableEvents = True
End Sub

View 9 Replies View Related

Automatically Add Blank Columns

May 28, 2007

I import a spreadsheet each month that summarizes expenses. The columns are the months: Col B=Jan, Col C=Feb, etc. I need to add a blank column between each month. Next month the import will have: Jan, Feb, Mar. Then the next will have Jan, Feb, Mar, Apr. macro that would add the blank column between months. Since the spreadsheet columns are growing each month the macro would have to be able to count how many columns to insert.

View 6 Replies View Related

Hide All Blank Columns With VBA Apart From Column A?

Aug 22, 2013

I just want to Hide all the blank columns on the sheet apart from column A.

I already have this code, just dont know how to alter it:

Sub HideEmptyColumns() Dim c As Long
Dim n As Long
Application.ScreenUpdating = False


View 2 Replies View Related

Formula Blank If Columns Not Filled Out Yet

Aug 10, 2014

I have this formula:


However i need that formula to be blank if columns C and I are not filled out yet

View 2 Replies View Related

Blank Counting Amongst Two Data Columns

Oct 17, 2013

So, in general I do have two columns F and G taken from the other xls.

Age is obviously difference between today and open date

Open date is open date.

I made a table like:

Age and due date.png

In this case, I have 3 rows where there is no open date extracted, therefore is no age. The counter stops on them and shows 529 in total instead of 532 or shows the age as far more than 365 days. How can I count the blank cells, but only in the range of the list I do have, not the all blanks I have from the beginning till the end of the column, so I could (for similar in this case) have 3 blanks cells counted?

Sometimes is also stuck in the middle of counting (when blanks are inside there) and the total number is even smaller. What function can I use to count these 3 (or less, more inn the future) as BLANK to have the total numbers realistic?

View 6 Replies View Related

Select All Non Blank Data In Columns

Nov 7, 2008

I need to select all data in columns A:F but the number of row containing data is variable. I need to select only the rows with data.

View 7 Replies View Related

Unlock Columns If Column Is Not Blank In Any Row

Jan 30, 2009

Unlock columns if Column is not blank in any row

Using VBA
On Sheet("Draft Final") , search every row and

If Col A is not blank, then unlock Columns G: M and unlock Columns O:U

View 4 Replies View Related

Macro To Specify Blank Cell / Columns?

Mar 28, 2014

I extract data from a database and export it to excel, the data has A-E Columns.

Then I run a macro to perform calculations based on columns A-E,

The macro results in creating columns F - K. I have specified to run the macro on columns F-K.

Now in the future I would want to increase my database and add in more columns for example F-Hand this would directly effect my macro.

Is there a way to specify in the macro to conduct calculations that is "F-K" after "A-H" that is as soon as you hit a blank column/cell?

View 1 Replies View Related

Identify Blank Rows & Columns

Mar 19, 2008

What is the syntax that I have to use to identify whether or not an entire column or a row is blank? Specifcally I want some code where I can say if row 1 is null, or blank then delete the entire row or. if column A is blank then delete entire column

View 2 Replies View Related

Days Between Dates Blank If One Or Both Columns Have No Date

Jun 2, 2014

I'm attempting to write a formula that will allow me to determine the number of days between two dates but to leave the cell with a zero in it if either of the first two date cells are blank or have N/A in them. Here's what I have so far:


This will give me a zero in the cell if both date cells are blank or will give me the days between if not. How do I get it to also put a zero in the cell if only one of the date cells is blank?

View 2 Replies View Related

Delete Blank Columns And Rows In A Different Sheet?

May 27, 2014

I have command button in Sheet 3 (from where I will be running the macro) and I need a macro which will delete all the blank columns and rows in the data containing in Sheet 1.

View 2 Replies View Related

Limiting Filters To Exclude Blank Columns

May 24, 2013

I have a spreadsheet with data in every other column (i.e. A, C, E, etc.). I am using the "filter" option in Excel on the aforementioned range of cells although the little filter icon shows up on all columsn, including the blank columns in between my data. Is there a way to only have the filters show up on the columns with data?

View 2 Replies View Related

Only Countif Cells Adjacent To Columns Contains A Blank?

Apr 22, 2014

I have a formula (below) where I want it to count the cells that contain a date that is less than or equal to today, but only when the adjacent cell is blank. The latter part of the formula works, but I'm struggling to tell it to only do the count when cells in column I are blank;


View 9 Replies View Related

Advanced Sorting With Blank Rows In Columns?

Jun 10, 2014

I have been trying to sort an excel spreadsheet to no avail. I have read mutliple posts and searched online but I can not find a solution. This is what I have. I have three columns of data. column A is an account name. column b has some insurance coverage info and may have multiple rows that go with column A. Column C has the effective date of the coverages in column B. I want to sort column A in alphabetical order but when I have tried it does not keep column B and C together with column A.

Column A Column B Column C
company 1 General Liab 5/1/14-15
Workers Comp 2/1/13-14

company 2 workers comp 2/1/13-14

company 3 crime 5/5/14-15
D&O 5/5/14-15
Fee 4/15/14-15

View 5 Replies View Related

Insert A Blank Column Next To Heading Columns

Feb 20, 2008

I am doing a lookup, populating a column (which works although slowly) then (in this part) doing a search on the header row.. If the heading contains the word "Category", I wish to insert a blank column next to (the column containing the heading), colour it yellow then look for the next heading and repeat if found.

It appears to clear my first row so I must have my columns referred incorrectly as rows

Dim FWord As String
Dim i As Integer
Dim lCol As Long
Dim MyString As String
FWord = "Category"
lCol = Range("A1").End(xlToRight).Column
For i = 1 To lCol
Cells(1, i).Value = MyString '

View 9 Replies View Related

Insert Cell To Columns Having X Blank Cells In Row

Aug 25, 2008

I need to put an extra "spacer" cell in each row that contains either 8 or 9 blank spacer cells in columns A through H or A through I, respectively, so that everything in those rows shifts to the right by one column. The problem is that all the other rows don't need any extra spacer cells. There is no pattern to the rows that need the extra spacer cell (such as every 5th row, or something).

View 3 Replies View Related

Hide Columns If Cell In Specific Row Is Blank

Jan 19, 2007

I have a row in a table from columns C to CZ. All the cells in the row contain a formula, between 1 and 204 cells in the row will have a value (i.e. will not be blank).

The cells with a value will start at column C and may or may not have a blank cell before no more values and blank cells to the end (Col GZ).


C D E F G H I J K >..........................GZ

23 34 67 74 2 34 6 2 56 all blank ("") to end


C D E F G H I J K >..........................GZ

23 34 67 "" "" 34 6 all blank ("") to end

I need to hide the entire columns when the cells in this row are blank but NOT if the blank cell has valued cells after it (i.e. do not hide columns F and G in the second example.

I can do this by looping back from col GZ and hiding the columns one at a time, which is very slow. I am stuck on the code to select all the relavent columns and hide together.

View 4 Replies View Related

Hide Blank Rows Which Spans Two Columns

Sep 15, 2007

Hide Multiple rows. I have text within two columns A, D. How can I Hide Blank rows which spans two column Named Ranges, "Range1" (A1:A15) "Range2" (D1:D15). As an example:

Beginning with this:



To this , after hiding blanks:


View 2 Replies View Related

Text To Columns Macro With Blank Cells

Jan 3, 2008

I'm using the the Texttocolumns method in a Macro, and when it runs across a cell without any data I get "Run time error '1004' No data was selected to parse". How would I get passed this? I would like it to just remain a blank range without the error. Here's the code I'm using:

Selection.TextToColumns Destination:=Range("F38"), DataType:=xlFixedWidth, _
FieldInfo:= Array(Array(0, 1), Array(5, 1), Array(13, 1), Array(21, 1), Array(25, 1)), _

View 2 Replies View Related

Copyrights 2005-15, All rights reserved