Excel 2010 :: Cannot Unhide Columns By Selecting Entire Worksheet
May 29, 2012I have Columns A to C which are hidden. I have tried to unhide these bey selecting the entire worksheet but to no avail. I am using Office 2010.
View 4 Replies
ADVERTISEMENT
Excel 2010 :: Selecting Certain Desired Columns At Once
Dec 5, 2011I wish to select all the cells which contain the word " Available " in column A at once . But i didn't find any option to do so using excel's Go TO Special feature.
I am using Excel 2010.
Excel 2010 :: VBA Selecting Only Certain Columns In A Table
Sep 10, 2012I have a table in columns C:J, starting in row 7. I have a macro that selects and copies the whole table (after I filter the table) and pastes to another sheet. Recently I've realized that I can only copy/paste C:I or it will mess up my formulas during the process.
This is the code I have right now, which works beautifully for the whole table:
Code:
ActiveSheet.ListObjects("Table36").Range.AutoFilter Field:=6, Criteria1:= _
"=Alan", Operator:=xlOr, Criteria2:="="
Range(ActiveSheet.ListObjects(1)).Select
Selection.Copy
What I need is to know how to copy everything in the table except column J. I can't just copy a certain range cells because the number of rows is variable. There has to be a way to modify the ActiveSheet.ListObjects("Table36") right?
Using Excel 2010.
Excel 2010 :: Selecting Corresponding Values From Multiple Columns
Feb 18, 2014I have a spreadsheet with two date/time columns 'Date1' & 'Date2'. Each date/time column has its own column with corresponding values ('Var1' & 'Var2'). These dates cover the same time period, however values for 'Var2' were collected less frequently than 'Var1'. I want ONLY the values in 'Var1' that correspond to the dates in 'Date2'
I am trying to select values from one column 'Var1' which have correlating date/time in column 'Date1' that match the dates specified in 'Date2'. Basically I need the values from 'Var1' that match the same date/time as 'Var2'
See the attached image to make it clearer..
Excel2010
Excelhelp.jpg
Excel 2010 :: Unhide Next Row Without Data
May 23, 2014I have an input spreadsheet to capture site addess details using Excel 2010
The Site Name is in Column A starting at row 8, each row is formatted with validation rules etc. but want only expose rows with data and one blank row to add next site.
So I needed code to unhide the next row without data - found what I needed in this thread
Have adjusted to my needs
[Code].....
It works by adding the next row but if I then delete the last rows Site Name I get a run time error with "Unable to set the Hidden property of the Range class" at follow code line.
[Code] .....
Excel 2010 :: Worksheet Move / Copy Function And Paste Special / Columns Widths
Mar 18, 2014I am trying to copy one worksheet using the "move/copy" function that is available when you right click a tab name and want to copy the worksheet in the same workbook
The steps I'm using are:
1. Right click the tab name
2. Select Move or Copy,
3. Select Create a Copy
4. Click OK
Doing all of the above does not work. When the new worksheet opens, all columns are the same width. It seems to be stuck on "autofit column width" setting of 8.5. The original worksheet is several columns wide all with different width settings.
I've also used Copy, Paste Special and selected column widths and that does not work either.
Excel 2010 :: How To Hide And Unhide Worksheets
Oct 4, 2013I have an Excel 2010 file with 10 worksheets. I would like to set up two VBA codes to attached to a two button; one to hide specific worksheets, the other to unhide. The specific worksheets are:
Calculation Sheet
GL Receipt
Sheet2
Cannot Unhide Columns In A Worksheet
Feb 27, 2009The workbook contains 5 worksheets, 4 of which will unhidden just fine; the remaining worksheet ("AnnualBudget" refuses to unhide columns AD to IV. Of course, this is the sheet that contains data in those hidden cells and I cannot get to the data. The sheet is unprotected and all freeze panes removed.
I have copied this sheet to a new sheet in the same workbook:
If I copy only formulas and number formats, the new sheet has all columns unhidden. If I copy formats, I have the same issue with the new worksheet. Its like these columns are forever locked from view.
FYI I am using Excel 2007 with a 2003 compatability worksheet
A copy of the workbook is attached. Any idea whats happening?
Excel 2010 :: VBA Code That Will Hide / Unhide A Row When Used With Checkbox
Jun 22, 2014I need a VBA code that will when used with a Form Control "Check Box" will unhide / hide a row. To be more exact, I'm needind the code to "Hide" row 34 when unchecked and "Unhide" the same row when checked. I'm using Excel 2010.
View 9 Replies View RelatedVBA Script To Hide And Unhide Specific Columns Within A Worksheet
Oct 24, 2006Need the VBA script to hide/unhide specific columns within a worksheet.
View 9 Replies View RelatedExcel 2010 :: Add Colour To One Cell By Selecting The Other?
Apr 29, 2013Im creating some labels for users to be able to enter data with ease. i want to add color to one cell by selecting the other. example:
if i put a (date) in cell B1 i would like cell A1 (Day) to colored once a date is in cell B1
Note: I am using excel 2010.
Excel 2010 :: Selecting Or Activating Cell Within Loop?
Apr 28, 2014After adding worksheets, data to ranges, etc. I want to step through each worksheet and "Select" or "Activate" a specific cell (Mainly to clear all the range selections).
My code does the job except the second to last part of cell selection/activation.
Win7, Office 2010
Excel 2010 :: Copy Entire Row If Cell Contains Specific String
Apr 5, 2012I am a total newb to excel and vb, and only have minimal experience in embedded C.
I have a very large spreadsheet with 9 columns and the max number of rows that excel supports (office 2010).
What I want to do is copy the entire row of data IF a cell in that row contains a specific string I'm interested in.
If it's necessary, the column that contains the values that would trigger a row copy would be column C and the data would be pasted onto a new sheet.
Excel 2010 :: Return Oldest Date In Entire Sheet
Mar 19, 2014in Excel 2010, whether using VBA or otherwise;
1) how can I return the oldest date in the entire workbook (or at least in the entire sheet if it's not possible to find that date in the entire workbook).
2) how about the most recent date ?
Excel 2010 :: Highlight Entire Record Based On Value Of Single Cell?
Apr 10, 2013MS Excel 2010, WinsXP
how to highlight an entire record based on the value of a single cell?
I would like to highlight all records grey where cells in a column = "closed".
Excel 2010 :: Pivot Table Conditional Formatting - Highlight ENTIRE Row
Aug 16, 2013I am using Excel 2010. I have a pivot table where I want to highlight the ENTIRE row where a certain cell value equals something.
In essence I want all the Material Subtotal Rows highlighted "Orange" But as you can tell from the picture below I am having issues with the Body of the Pivot table. I have the formula checking to find whenever it finds the word total to highlight it.
The example below is showing how I need the row to be formatted. I can get the Data (Units) section formatted no problem. It is just the other part of the pivot table that I cannot format.
For the columns from Material to SAP # I have been trying to use Dynamic Name ranges using the Offset function. However, excel turns that Name range to a range and if I filter the pivot table, it adds extra ranges to the Applies to box and starts to really mess it up.
Excel VBA - Selecting Range Of Data Considering Multiple Columns
Feb 11, 2014I would like to loop through cells row wise.
Columns which have data are A:E
modify below code to select the range from columns A to E?
[Code] ........
Hide/Unhide Entire Row With Button IF
Feb 9, 2010I'm trying to get a Button to hide and unhide rows depending on Column A only which is a pasted link to other sheets. The rows should hide when Cell A is empty or 0.
or 2 buttons one for hiding and the other for unhiding rows.
Excel 2013 :: Formatting Of Entire Worksheet Changes Unexpectedly
Jan 20, 2014In Excel 2013 x64 (EN; CZ locale) I have this funny bug. I work on a large vba project and sometimes when I open it, every cell in every workbook that had default formatting now has this numberformat (shown as "Accounting")
"_-* #,##0.00 [$Kč-405]_-;-* #,##0.00 [$Kč-405]_-;_-* ""-""?? [$Kč-405]_-;_-@_-"
its seems that this formatting is assigned to styles --> Normal and it just messes up everything (pivots, slicers...) and cannot(!) be undone.
I have made some routines to check for this error on workbook.open and workbook.close and I also have file versioning. I check for the error regularly on every worksheet change, but it never comes up, nor does it whenever I close the workbook, so Im having hard time detecting when it occurs.
Sometimes when I try to open the workbook its just all messed up. When I go trough the versions, couple of them back still has the error which means it was already saved with it.
All I could figure out so far is that it sometimes happens when I try to copy some cell and paste it elsewhere (but later it works fine)
I'm 99.9% sure that my code is not causing it by accident or purpose. Now I just found the problem on different workbook that might have been opened at the same time. If you're interested, have a look here [URL] ......
Hide And Unhide Rows By Selecting A Letter From A Combobox
Feb 28, 2007i have a combobox and have A, B, C, as options in the combobox
then I have a table from row 10 to row 50
if A is selected from the combobox, I want excel to show only rows 10 to 20 and hide rows 20 to 50
if b is selected from the combobox, I want excel to show only rows 20 to 30 and hide rows 10 to 20 & 30 to 40
if c is selected from the combobox, I want excel to show only rows 30 to 40 and hide rows 10 to 30 & 40 to 50
in other words, i want all rows 10 to 50 hidden at all times, until a selection A, B, C is made in which i want thoes related rows to be shows and all other rows between rows 10 to 50 hidden.
Selecting All Data In Specific Columns Without Selecting Adjacent Column
Mar 10, 2014Using VBA, I need to Select A1:C14.
The problem is that A1:C14 contains blank cells, and there is also an adjacent column D that I do not want to copy.
So, UsedRegion and CurrentRegion aren't doing it for me. (It selects Column D too.)
Obviously, this is an example...the real data set is an export and varies in size.
Excel 2013 :: Copy Entire Row If Cell Contains Specific Text And Paste Values Into Another Worksheet
Jun 23, 2014I am using the code below in Excel 2013.
Sub Test()
For Each Cell In Sheets(1).Range("J:J")
If Cell.Value = "131125" Then
[Code]....
This works great except that it pastes formulas. I would like to paste values only. I've tried
" PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False" and it gives me an error.
How To Highlight Entire Row When Selecting A Cell
Feb 23, 2013Is there a way to highlight and entire row automatically every time we select a cell on that same row?
I have 20 columns of data and it's a mess when when need to scroll to the left or right since I lose sight of the selected cell and then I can't see which the row I want to check.
How To Stop The User Selecting Entire Row
Sep 18, 2008I want to stop the user selecting an entire row by clicking on the row header.
How can I do this?
Selecting Entire Rows Based On Contents Of Cell?
Jul 15, 2013I have a large set of data regarding the activities going on in particular rooms. The data contains activity name, start time, day, duration, room and size.
I would like to select all rows that contain a cell in the activity name column which contain the words 'VideoConference'.
I have tried to Search, Select All then index the remaining data using =iferror(index(etc. However some activities occur in more than one room and all variables apart from 'Room' are the same. Thus when I have tried to index the room column I get the same room for both rows.
ps the raw data set consists of +28000 rows so I can not simply look through and copy.
Excel 2010 :: Move Part Columns Of Data From 6 Columns To Form 1 Large Column In Column A?
Jan 31, 2013I have a large spreadsheet converted from pdf whose data still appears in A4 reading format.
I need to move part columns of data from 6 columns to form 1 large column in column A.
For example, move range B8 to B76 beneath range A8 to A76 and range C8 to C76 beneath that etc, page by page working through all 270 pages !
Also need to delete unnecessary 'page headers' throughout as in rows 2-6
Excel 2007 :: Automatically Transfer Columns From One Worksheet To Another In Multiple Columns?
May 4, 2013I would like to take the data from worksheet1 and put into worksheet2 but limit the length of a list (the real spread sheet has over 100 rows and i would like them in 4 sets of 25 versus the example I provided). Is there an array or macro that would make this work (keeping the formatting)..
Excel 2007
B
C
3
Name
Company
[Code].....
Excel 2010 :: Import CSV Into Worksheet
Dec 11, 2012Excel 2010 / Win 7.
I have some code that imports a csv file into a workbook. This works fine when i use a file named .csv. I was hoping to use a random file name (in this case .bmhs) so that we can determine which files we need to import.
The problem i have is when importing a '.bmhs' file the data comes in column A and is a comma seperated list. If i use .csv then the commas are used as the column seperators (which i need).
impFle = Application.GetOpenFilename(filefilter:="BMHS Files, *.bmhs", Title:="Select Import File")
would give me 1,2,3,4 all in column A
impFle = Application.GetOpenFilename(filefilter:="CSV Files, *.csv", Title:="Select Import File")
would give me 1 in column A, 2 in column B, 3 in column C and 4 in column D.
Is there any way that i can maintain using my own file name (.bmhs) but have excel treat it as a csv file.
Excel 2010 :: Set For Specific Worksheet
Jul 30, 2014I am using lesson 33 of Excel VBA and Macros with Mr Excel as my guideline. The coding is as follows:
Dim WBO As Workbook 'original workbook
Dim WBN As Workbook 'individual data workbooks
Dim WSL As Worksheet 'List of files worksheet
Dim WSN As Worksheet
Set WBO = ThisWorkbook
Set WSL = WBO.Worksheets("List")
Set WSD = WBO.Worksheets("Data")
[Code] ......
I have indicated above with ( ) the beginning of my problem.
From the workbook with the list of workbooks to open, in each case I want to refer to a worksheet in each workbook
named "Report" and grab all the rows with data exept heading (rows 1 & 2) and 9 columns.
How do I get WSN in the code above to include the worksheet named "Report" or do I need different coding. Using Windows 7 & Excel 2010.
Excel 2010 :: Comparison On Two Columns
Jun 20, 2013I have two columns (A and B) with the same data. Column A is missing a value that is in column B.
Column A has 11330 rows whereas Column B has 11331 rows.
I am trying to do a comparison on the two columns to determine which value is missing from Column A.
I am using Excel 2010.