Unable To Display Cell Value When Cell Is Hidden

Feb 18, 2010

I found some code that is working great, but I'd like to add some functionality to it if it can be done. When a cell is clicked in Column G it is displaying a % found in Column F in the same row as G under the cell similar to a comment without using the comments option. The problem I'm finding though is that if Column F is hidden then it is not displaying the results in the cell found in Column G. Here is the


Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Row As Integer
Dim Amount As String

Row = ActiveCell.Row
Amount = Range("F" & Row).Text

Basically I'd like to know if it is possible to show the comment in G if the Cell it is trying to reference is hidden.

View 9 Replies


ADVERTISEMENT

Unable To Set Hidden Property Of Range Class

Mar 19, 2014

I locked the cells on Sheet1 from B4 to B10.

I protect the Sheet1 Review > protect sheet and selected two checkboxes from protect sheet property "Select locked Cell" and "Select unlocked cells".

It is working fine and it does not allow the user to view the locked cells B17:B24 while protection is on.

I have a RadioButton1 on the same Sheet1 and i put the following code behind the button to hide the 4 up to 10 rows. When i will press the button while password protection is on; it is giving me the following error:

Unable to set the Hidden property of the Range class.

View 7 Replies View Related

Unable To Set Hidden Property Of Range Class ActiveX Combobox

Jul 30, 2013

Here is my code:

Code:
Private Sub ComboBox1_Change()
ActiveSheet.Rows("3:62").Hidden = False
Range("D1").Value = ComboBox1.Text
End Sub

I get a runtime error '1004' when I make my combo box selection. I don't have any security or password protection type stuff. The combo box is part of a more complicated spreadsheet and I don't want to switch to a data validation type drop down and I really want it to be activeX.

View 4 Replies View Related

Hiding Columns: Unable To Set The Hidden Property Of The Range Class

Oct 31, 2006

I have recently tried to implement the password protect from viewing code from this site. It worked brilliant on a basic spreadsheet, but when I tried to implement it on a worksheet with links I keep getting the error:

Run-time error '1004'
Unable to set the hidden property of the Range class

View 9 Replies View Related

Excel 2000 :: Unable To Hide Hidden Column When Save As Webpage?

Aug 15, 2013

Currently I'm using excel 2000. Can't hide hidden column when save as webpage?

View 2 Replies View Related

Unable To Use Arrow Keys To Select Hidden Cells On A Protected Workbook

May 13, 2009

I have a problem with a spreadsheet I am working on, and I'm not sure if its something I've done, or whether its corrupted.

Basically, Column A is Hidden and not Locked in the protection tab of formatting. The other columns are Locked and not Hidden.

I used to be able to use the arrow keys to scroll through Column A, but this now doesn't seem to work. I can select the cells within column A with the mouse and I can scroll with the mouse and the scroll bars, but I can't move between the cells with the arrow keys, enter button or tab button.

Does anyone know what might be causing this, or is the workbook corrupt?

View 9 Replies View Related

Excel 2010 :: Runtime Error 1004 / Unable To Set Hidden Property Of Range Class

Jun 25, 2013

I am using this code (below) to hide certain rows or columns depending on what number is entered. Everything is working fine and I am at the point where I would like to share this excel sheet with others but I would like to lock certain cells so that others cannot alter the formulas. As soon as I lock the cells and then enter values into the unlocked cells, I get the "run-time error '1004': Unable to set the Hidden property of the Range class".

I am using excel 2010 x64.

Code:
Private Sub Worksheet_Change(ByVal Target As Range)If Not Intersect(Target, Range("B3")) Is Nothing Then
If Range("B3").Value = 0 Then
Columns("G:P").EntireColumn.Hidden = True
Else
If Range("B3").Value = 1 Then
Columns("H:P").EntireColumn.Hidden = True

[code]....

View 3 Replies View Related

Unable To Get The Task Pane To Display On Startup

Oct 9, 2008

I am working in Excel 2003 and have recently lost the Task Pane when I start Excel. The box in Tools Options to display the task pane is checked. I have modified the registry to include a DoNotDismissFileNewTaskPane value and have even added the following code to the Personal.xls file:

Private Sub Workbook_Open()

On Error Resume Next
Application.CommandBars("Task Pane").Visible = True

End Sub

If I remove the On Error Resume Next line I get the following error:

Runtime error '-2147467259 (80004005)' Method 'Visible' of object 'commandBar' failed

I did add the Analysis Toolpak last week but am not sure that this had anything to do with it.

I can go into the View menu and show the Task Pane and do have the CTRL+F1 option to display it.

View 9 Replies View Related

"Unable To Set The Hidden Property Of The Range Class" When Unhiding Cells

Oct 30, 2009

I'm trying to unhide all the cells in a worksheet, but keep getting the "Unable to set the Hidden property of the Range class" error and I'm not sure what to do.

View 2 Replies View Related

Internet Explorer Script: Unable To Display Certain Objects

Nov 10, 2006

Recently my HELP was unable to display certain objects. Now I get an Internet Explorer Script Error message popping up almost ever time I display Help.

View 2 Replies View Related

Look At Data From One Cell Reference Another Cell Then Display The Results From The Cell Next To It

Jun 19, 2008

I have 2 problems relating to LOOKUP.
Not sure if Excel can perform these calculations as they could get to complex.

Problem 1
Can it be possible to have excel look at data from one cell reference another cell then display the results from the cell next to it in another cell, sort of example:

Tab 1 (Never changes)
AB
Bob1
Jon2
Fred3

Tab 2 (Dynamic, changes each week)
AB
Jon
Fred
Bob

So it would work as follows.
Tab2 column B will take Tab2 column A’s data check Tab1 column A and display Tab1 column B’s result.

Problem 2

Weekly league rank table that shows position movements week by week
Example.

Week1
1Jon
2Bob
3Fred

Week2
1FredUp 2
2BobNot Moved
3JonDown 2

Can Excel calculate/show the actual movements of league positions?

View 9 Replies View Related

Cell B1 To Display True If Any Of The Values In Column C Match Otherwise I Want To Display FalseOR Function Confusion

Dec 16, 2008

Example:....

i m wanting Cell B1 to display true if any of the values in column C match otherwise I want to display false.

A 1
B 0
C 0
D 0

But I can't determine how to get this done.

View 5 Replies View Related

Unable To Use Cell For Reference Which Has Formula?

May 4, 2014

I have one coloumnA with formula =IF(F4="","",(H4-F4)) ------ the result I want to use for reference in which I am unable to use the result value using below formula.
I have one more cell B with month & date

Currently using formula =SUMPRODUCT((TEXT(A4:A1501,"mmmyyyy")=$B4&$C4)*('Credit Cards&Loans Transactions'!J4:J1501))
Cell B4 has month & C4 has year.

J4:j1501 cell has the formula "=IF(F4="","",(H4-F4)) " , I want to use the result of cell in above formula.

View 3 Replies View Related

Unable To Format Number Within Cell

Jul 25, 2008

Working on matching 2 column of numbers.

Unable to match as 1 column has format where number has a space in front of first character.

_425638 as opposed to
425638

Not an underscore tough

Have tried text to columns - have tried editing cell and replacing space with nothing via edit/replace but no joy only way appears to be entering cell and deleting manually - there are thousands to update.

View 9 Replies View Related

Unable To Format Date Properly Pulled From A Cell

Feb 26, 2014

In cell B5 of sheet1 contains a date which changes everytime when i open excel file. The date is in the M/D/YYYY format.

I am using the following code to use that date in MM/DD/YYYY format.

[Code] .....

If cell B5 of sheet1 is 2/1/2014, but my code is resulting in wrong as 01/02/2014.

View 3 Replies View Related

Cell Is Hidden Or Not

Feb 23, 2009

I'm trying to create a custom function that will return if a cell is hidden or not. I have it working with just a single cell being called

View 11 Replies View Related

Excel 2010 :: Unable To Recognize Cell That Contain Colon Correctly

Oct 4, 2011

i have encountered a problem which happens when you write data that contain : in an excel sheet (i use excel 2010)

for instance if i enter to one of the cell 45:58 excel sees it as 01/01/1900 21:48:00 when i try to get the information by using a function i will get the wrong data for example typing in the different cell LEFT(Cell,5) will result 1.908

(i receiving the data from an outside source in this way and i need to make analysis)

i have noticed that the first 2 digits (21 in the example) are related to the number i have choosen in a 24 hour cycle for instance

24:58 will result 01/01/1900 00:58:00
26:58 will result 01/01/1900 02:58:00
48:58 will result 02/01/1900 00:58:00

View 7 Replies View Related

Cell Referenceing (display The Value In The Cell Offset By X So I Can Bring The Numbers From Sheet1 Over)

Jul 17, 2009

Sheet1 is a list of names, then a few columns of numbers.
Sheet2 contains calculations based of the numbers in sheet1.

Each sheet from 2 on is names after the names in sheet1 column A...
A large cell at the top of each sheet contains the formula to display the sheet name:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

So what I want to do now is...
in cell, look for the cell in sheet1, and display the value in the cell offset by X so i can bring the numbers from sheet1 over.

In plain english the cell would say like...
"look in sheet1 for "Name" then display the cell next to it"

I know to look in the next sheet its "=Base!B2" if i wanted b2 on sheet base.
I know to use "=OFFSET(Base!B2, , 1, , )" too look at B2 and go right 1 column.
But the issue is i dont want Base!B2.. i want whatever cell in Base column A that has the text that A1 has.

View 2 Replies View Related

Increase That Amount By A Percentage Identified In Another Cell And Display The Value Only Without Any Formalas In A New Cell

Jan 19, 2009

If a cell is not blank, then increase that amount by a percentage identified in another cell and display the value only without any formalas in a new cell. To this end I wrote this IF statement:

=IF(I2>0,CP9=(CA9*I2/100)+CA9,CP9="")

Observation: I see a FALSE in CS9 where this IF statement exists, however, CP9 does not display the required value.

View 8 Replies View Related

Excel 2010 :: Display Cell Ranges From Multiple Locations Based On 2 Cell Values?

Jun 4, 2013

I need to display a set of cells based on the value of two drop down cells i have. As I am not very good at english and worse at explinations, I'll try via screen shots...

I have two dropdowns (C4 and C6) that will indicate what table to use (Second sheet / screenshot). I want that "table" to display in the yellow box on the first page. To complicate matters, some options do not have a CLA option - those starting with X. As there are 24 different outcomes and each is 3x9 if/then statements just dont seem to cut it.

P.S. I have excel 2010 and windows 7

View 1 Replies View Related

Cell Date Formatting: Cell To Display Mm/dd/yyyy And Enter Mm/dd/yy

Aug 13, 2008

I have Excel 2000, recently when I format a cell to display mm/dd/yyyy and enter mm/dd/yy, it is displaying dd/mm/yyyy. Or it starts out correctly and during a future opening of file it displays incorrectly.

View 2 Replies View Related

Listing Number In A Cell To Display List Of Items In Another Cell

Apr 24, 2014

When inserting "1" in the cell under soup, i was thinking it will bring up a list of its ingredients and how much of that ingredient. The values are listed in the same spread sheet below.

The amount of the ingredient is in D50 (80grams) and the item type next to it in E50(onion)

Is it possible to put in "1" soup then it displays all the items in both those cells range example(D50-E50 to D60-E60)?
Is it possible to put the value "2" in soup and it shows double the measurements? example (160grams) (onion)

View 4 Replies View Related

Macro To Find Match Delete It From The Cell Display It In Different Cell

Apr 23, 2008

I have a huge database. I am looking for a macro that can search for a particular word. If a match is found, the macro should do two things simultaneously... (i) delete the contents of the cell in which the match is found........(ii) display the same contents 1 row below and 1 coloumn to the left of this cell where the match is found. For e.g....

View 9 Replies View Related

Using IF AND Formula To Display A Cell With (0) As Yes But It Also Returns Empty Cell

Apr 14, 2014

I wrote an IF AND formular to display "Yes" for a cell with zero. but when the cell is also empty, it still returns a "Yes" instead of empty.

this is the formular:

=IF(J2=3,"Yes",IF(AND(E2="",I2=0),"Yes","No"))

when I2 = 0 it returns Yes

Also with I2 = "", it still returns "Yes" instead of "No"

View 6 Replies View Related

Find Row Max And Display Cell Contents Of Cell To Left?

Aug 12, 2014

I have data arranged in cells A1 to Z1 as Name1, Amount1, Name2, Amount2, Name3, Amount3, etc. Is there a formula that can determine the name that corresponds to the maximum amount in the row?

View 7 Replies View Related

Display Contents(text) Of A Cell Referenced By A Given Cell

Feb 9, 2009

I want to display the contents of cell B5 in A7 by using cell C7 to show the location of the cell to be displayed. Cell C7 has a formula that shows the cell location of information (text) that needs to be displayed. How can I show in A7 the contents of cell reference shown in C7? In figure attached I show an example to better understand. Want in A7 to show the contents of B5 by reading what is in C7. So A7 cell should show word Road.

View 3 Replies View Related

Display Cell X Of Range Based On Another Cell Number

Feb 18, 2008

I am trying to create a table, based on what people predict in sports games. I have most of it in place, but I have hit a brick wall where one part of it is concerned. For example, cells M43:M56 have the scores for each week of what one person predicted., so it could be 2,5,7,2 and so on. What I then need the table to do is determine which round or week it is and display the relevant score. So based on the above let's say it's round 3, and his score would be 7 for the week, and the cell to the right of this shows the week's score plus his total score so far.

View 2 Replies View Related

Keep Row HIDDEN Until Specific Cell Has Been Reached

Feb 12, 2007

I want to Freeze my Header Row (A16 to T16) on my spreadsheet but I can't seem to get it to freeze. I wanted to have it freeze when that row reached the Top of the page but all I can do is freeze it and the 15 rows above it. Can one row be made to be visible at all times? I don't think so as I asked this question before but thought I would start by asking it again...

Now my workaround for that was to put the header row at the top of the page as well and freeze it. This works but when you initially open the spreadsheet it look weird because you see a header row on top and one 15 rows below it.

My question is is there a way to hide row 1 until a specific cell becomes active and then the code can undide the row? I want row one to become visible when the user gets to cell A41. Does anyone know how I can accomplish this or do you have any other suggestions for me to try?

View 9 Replies View Related

Hidden Columns With Cell References

Aug 4, 2009

i have a Macro that gets rid of Hidden columns and Rows.
but i kept getting REF# errors.
so i changed the macro to Paste as values before the rest of the macro.

but then my Subtotal's dont work.

macro that only Paste the values of formulas that refer to a hidden cell?

Sub Prepare_Workbook()

Dim lp As Double
Dim wsht As Worksheet
Dim Buttons As Object
Dim Calc As String

Calc = Application.Calculation
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

View 9 Replies View Related

Last Cell Used In Column When Rows Are Hidden

Apr 14, 2007

1. find the last cell used in a column when the rows that contain the data are hidden. I tried using Range("A65536").End(xlup).Select. but when the rows are hidden it doesn't give me the last cell used.

2. I am trying to restrict my search to just one row. When I try using the cells.find function it looks for the whole sheet but I just want it to search for some particular data in just one row or a specified range.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved