Blank Or Grey Area In The Left Of The Screen

Apr 30, 2008

I am running into a seemingly random event upon executing a rather long program in Excel VBA: a square area turns gray in the left of the screen in Excel, making invisible everything under it, and affecting every sheet and workbook open. The only way to get rid of it, so far, has been to restart Excel. I thought it pertained to a faulty Office installation (XP/2002), but then it also happened on another machine (with Excel 2003) where I installed the application.

View 4 Replies


Excel 2010 :: Shifting Cells Left And Then Up If Left Cell Is Blank?

May 8, 2014

I have a 2010 excel sheet containing 14 columns and 45082 rows in total. I am quite illiterate when it comes to writing macros but I know that what I need can be achieved with a set of codes.

To be more clear, I inserted two tables below. The first one represents the current data structure, and the second one is the way I want my data to look like.

Current data structure looks like
Variable 1
Variable 2
Variable 3


View 9 Replies View Related

Show/Position A1 To Top Left Of Screen

Apr 23, 2008

I have a very large workbook with multiple sheets and use macros to copy and paste all data as values, then delete some rows and columns depending on certain criteria. This starts at cell A1 and works right, then down.

This is then saved as a copy and distributed to a wide audience.

The problem is that when each page is opened up, the data shown is the bottom right of the whole sheet instead of the top left ( Panes are frozen for row and column headers).

View 9 Replies View Related

Blank Screen Background

Oct 15, 2008

I use a number of user forms and would like to dsplay them with a blank background ie not over the top of the spreadsheet. The colour of a blank userform would be nice! I do not want to make them the size of the screen.

View 4 Replies View Related

WebBrowser Control Only Displays A Blank Screen?

Apr 30, 2013

I have searched and found a lot of references to the web browser control for a user form. I have tried and tried but all I get is a blank webbrowser control.

I have tried the navigate and navigate2 methods and other stuff that you can see that I have commented out. Also, I tried placing the line with the navigate method both before and after the method. But all I get is a blank web browser on the form.

Here is what (sort of) I have tried:

Sub ShowTheForm()
'Dim myPerm As Office.Permission
'Set myPerm = ThisWorkbook.Permission


So, what's the trick. All the stuff I found searching the web implies that what I have above should work.

View 6 Replies View Related

Opening Excel Files - Getting Blank Screen

Apr 29, 2014

When I attempt to open a file I get a blank screen. If I try to close the window it asks if I want to save the file so it is must be open but not visible. Have I inadvertently clicked on an icon with which I am not familiar?

View 1 Replies View Related

Countif Left Cells Are Blank?

May 19, 2014

how to set up a formula that would count the number of numbers in a column, only if the cells before those cells are blank. In plain English: total the number of occurences in each column, provided the value in cellrow is the first occurence in that row starting at column A. E.G


Count would return under Column A, 1; under Column B, 1; (because row John has a value in AJohn it is ignored), under Column C, 2; under Column D, 0.

View 6 Replies View Related

Pull From Left Until Blank (Space)

Jan 5, 2010

I'm looking for a formula that pulls the text from a cell unti it hits a space. I'm using the formula below but keep getting #VALUE results. B1: =LEFT(A1,FIND(",",A1,1)). I know it's not that hard but can't figure it out.

View 4 Replies View Related

Return Blank If There Is No Value Or No Data In Left Cell

Mar 10, 2014

my question is how to return blank cell if i have no data inputted in left cell.. or if AH9 is blank or no data inputted AI10 will be blank using this formula.. =IF(AH9<75,"A",IF(AH9<82,"B",IF(AH9<87,"C",IF(AH9<92,"D","E"))))

View 2 Replies View Related

Cells Left Blank When Using Data Validation

Mar 4, 2003

I am using Data Validation and I don't want the user to go past a cell without putting in an entry. When I leave the box (ignore blank) unchecked it doesn't do anything after I have protected the document.

View 9 Replies View Related

Fill Blank Cells With Data On Left

Dec 14, 2007

I have a macro that creates mutiple, though varing numbers of, columns. Once the columns are created, a blank column is set up to the right of them. When the data is ideal, only one cell in each row created by the populated columns will have data in it. So lets say that in this example, the macro created 23 columns of data. A1 is blank, B1 is Widget, and C1 through the end are also blank. I need a macro that will look at the rows and find the populated column and copy that string of data to the blank 24th column (to the right) created after the poulated columns. So X1 (the 24th column) will have Widget placed in it.

Now I need it to do one other thing. In another example, let say there are 5 columns created this time. In the third row, there is data in A3 and D3. If they are the equal to each other (A3 value being 143256 and D3 value being 143256), then I need the 6th column created to have 143256 placed in it. However, if the data differs ( A3 value being 143255 and D3 value being 143288) then I need the word "Scrap" to appear in the sixth column.

View 3 Replies View Related

How To Show All Results If Parameter Field Left Blank

Nov 3, 2013

I have three search boxes in XL , two are search from and to dates and the other is search be ref.

I can currently search by dates and ref but would like to show all records in the specified dates if the ref field is left blank.

I am using the query writer and referencing back to cells in XL. I don't use the wizard or SQL. I have tried many options and think I should be using a OR statement with a wildcard but can't seem to get the result, does the wildcard just show the blank cells in the actual data?

View 1 Replies View Related

Macro To Check Validation Dropdowns Left Blank

Oct 27, 2008

Got a table where I've placed Data validation - List on them.

Placed a macro on a button so that the data on the table where the validation list is placed is transfered to another sheet (same workbook).

What I need is a to modify the macro assigned to the button so that when the button is clicked to activate the macro:

a.) Can identify if there are any blanks on specified cells with validation list
b.) Stops the macro from copying the fields to the other sheet
c.) Alert the user of the blanks (an alert stating there is a blank would suffice)
d.) Alert should preferably be similar to a Stop alert from Data Validation.

Can anyone help? Been reading through several threads but don't seem to find anything that could help me - tried reading a Visual basic thread and now i've got a headache....

View 15 Replies View Related

Apply Conditional Formatting To A Cell When It Is Left BLANK

Nov 30, 2008

I'm trying to apply conditional formatting (shading) to cells that are left blank.

(Purpose: I am designing a research template for a client to complete with data and want the spreadsheet to show them where they've "missed a bit"!)

(When I go to the conditional formatting box, it asks me to specify when "cell value is"..."between/not between/equal to/not equal to" etc. But there's no option to specify when the cell is blank.)

View 2 Replies View Related

Removing Blank Cells From A Worksheet And Moving Everything Left

Feb 23, 2014

I am looking to remove all blanks from a table I have and move all the data left. Right now the data is by date, and some dates are blank for some players (it is a basketball sheet) and filled for others, but I want to see it by game. So I have what is in the first table below, and I want it to look like what is in the second.



View 3 Replies View Related

Grey Out Worksheet

Dec 8, 2009

I have a workbook with 3 sheets.
The underlying VBA is password protected and I have the password.

My problem is there is one sheet that I can see in the VBA side of things but cant see on the excel side

Format/sheet/unhide - suggest there is no sheets hidden

If I right click on the sheets (vba side) View object can be seen
except for the one sheet which remains greyed out

Any ideas why this is?

If I try and goto(F5) a range in this sheet nothing happens
If I use a dropdown validation cell, which looks at this sheet it works, except there appears to be a line missing.

View 9 Replies View Related

Grey Scale Text

May 15, 2007

We are trying to print grey scale text. It will only print grey scale when we print in colour and not in black and white?

The images and line fills we are using are printing in grey, just not the text.

We are using excel 2003. Both word and publisher print grey scale?

View 3 Replies View Related

Conditional Grey-out And Disabling Of Cells

Oct 1, 2008

I need to find a way to do conditional formatting and disabling of a cell based on a value from another cell. For instance if A1=X,Y, or Z, then B1 will get grayed out and cell entry will be disabled. This is so that when skimming over the sheet, you can tell what cells in row B you need to put info in still, and if it's grayed you'll know you don't have to put anything there (and it won't let you).

View 14 Replies View Related

Disable Grey Out Ribbon Items

Jan 19, 2009

For an excel application I need the disable most of the ribbon content i.e. disable insert, formulas tab etc.

The only thing that should function is a hand build menu add-in, which is created with custum UI editor.

I searched via google, this forum and many other places, but i didnt find a clear answer yet.

View 9 Replies View Related

Move Down Column And For Every Blank Cell Clear Contents Of Cell To The Left?

Jun 1, 2014

i need a code that moves down a column and for every empty cell in the column the cell to the left is cleared and then it moves on to the next cell down. the column is not always the same and will start from a selected cell, and the column will contain no more than 5 rows

View 3 Replies View Related

If Blank Cells, Paint Yellow. If Cell To Left Is Less Than A Number, Don't Paint

Sep 8, 2009

I have a spreadsheet which contains 39 columns with a header row. The number of rows varies per spreadsheet. I'm running into a problem with highlighting(painting yellow) cells. Really the problem is selecting the cells to be highlighted. The macro is skipping some of my code completely and in other cases leaving some cells unhighlighted.

1. All blank cells in row AG should be painted yellow.

2. If column AF contains a cell with number 900 or greater, then the cell in AG (same row) should NOT be painted yellow.

3. All blank cells in rows AC and G should be painted yellow. Some spreadsheets may not contain blank cells.

Problem with the VB is not performing the code after the first command. It will highlight MOST of the cells in AG but for some reason it is leaving a few blank ones unhighlighted. The blank ones are usually at the bottom of the rows. I have no idea why it would miss these.

I believe the "ucase" tag is incorrect since its looking for a number but I am not sure what to put in its place and if I use something else should I dim it as ""?

I've attached an excel spreadsheet which contains a sample to this problem. I've also attached what it should look like if my code worked.

View 6 Replies View Related

Prevent The User From Saving The Data Input From The User Form If Any Of Those Three Fields Is Left Blank

Feb 9, 2010

I have a user form that has a combo box "City" two text boxes one called "Flight" and the other "Date". What I'm trying to do is to prevent the user from saving the data input from the user form if any of those three fields is left blank. The code that I have so far checks all of the required fields, if any are left blank a message notifys which field(s) is left blank and return the focus back to that field. But the rest of code also fires.

What I really need is either to stop the code if any fields are blank and return the focus back to the blank field, the user completes the field(s) and clicks the save again, or better yet, pause the code until all the required fields are completed and then complete the save. (There is actually another 200+ lines of code in this sub, but I deleted it to keep the post a little shorter.)

View 2 Replies View Related

Print 2 Selected Area (highlighted Area)?

Apr 11, 2013

How can I print 2 selected area (highlighted area). I know there is a trick to do that. Right now I can only select (highlight) one area to print, but would like to know how to print 2 or more areas at same time

View 7 Replies View Related

Form Control To Grey Out Unused Rows

Nov 8, 2009

Is there a macro that will format unused rows or with no value in a given range. I have a sheet that I am using that some of the date is either added or deleted and would like to have a macro to do grey out unused rows. I am using this with a form control.

View 3 Replies View Related

Making Cells With Text Bold And In Grey

Jan 16, 2012

I have a spreadsheet with rows of cells which are either blank or have text in them.

Is there an easy way to write a formula which will make the cells which have text in them bold and make the cell colour grey. But if the cell is blank keep the cell white.

View 3 Replies View Related

Grey Out / Disable Cells In A Row Based On Frequency Value

Feb 14, 2012

Essentially, I'm creating a spreadsheet which contains a list of staff in rows, and the months of the year as columns. It is to record certain company checks which must be done (e.g. driving licence check). When a check is complete, the date it was done is entered under the corresponding month. Certain checks (e.g. driving license) only need to be done every 6 months. What I'm trying to do is find a formula/vba to look at each row, determine where (which month) the date was entered in, and grey out the 5 months in front, meaning the next check is required in 6 months time.

Ideally, the frequency of this check is dynamic, and can reference a cell (e.g. might change to every 3 months etc).

View 1 Replies View Related

Disable Grey Out Condition Formatting In Ribbon

Sep 28, 2012

VBA code to disable(grey out) condition formatting command in ribbon. Because I generated a template and do not want user to change the condition formatting.

I have tried below, but it did not work...

Application.CommandBars(1).Controls("Format").Controls("Conditional Formatting...").Enabled = False

View 5 Replies View Related

Get Text Inside Cell Which Is To Left Of First Blank Cell Of Column?

Mar 24, 2014

I want to get the text inside the cell which is to the left of the first blank cell of a column.

I show the problema in the attach imageSin título.jpg

View 6 Replies View Related

Application Onkey: Prevent Users From Using The Print Screen Or The Alt Print Screen Buttons On The Keyboard

Dec 29, 2009

I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).

View 5 Replies View Related

If One Cell Is Blank, How Do I Copy The Cell To The Immdediate Left

Apr 7, 2009

I have Column A and Column B. Every row in column A is populated, but only some of the rows in column B are populated. I need a formula that copies column A if B is blank. (i.e. If B6 is blank, copy A6). Thoughts?

View 6 Replies View Related

Copyrights 2005-15, All rights reserved