Okay, I've sorted my sheet the want want to view something, and have saved it as a Custom View. When I remove all of the filters, and test the view by selecting it, everything works except for the sort. I'd like for it to sort from smallest (number) to biggest.
Is this possible?
I haven't had much need to write VBA code in a few years, so I'm pretty sure this is straightforward.
I'm trying to copy paste a range of variable size and am getting a '1004' error when selecting to the right.
Basically, I have input data, and then output data which applies formulas to...
I'm probably being really stupid here but I have two different sets of data on the same worksheet.
I know how to find the last row of data on the entire worksheet even with empty cells.
I know how to find all rows of selected data for the first range, e.g. B2:B10 has data and B15:B20 has...
When I apply a filter to this document I'm using, a lot of the data suddenly goes missing.
I've got a lot of two digit codes that I'm sorting by and when I sort A to Z it only brings in the codes that are numbers and remains blank for all the other two digit codes that have letters...
I created a chart but can't find it. Is there a way to find charts? It just has a generic name like "Chart1", "Chart2" etc. I thought maybe the selection pane would help. On it i've tried selecting or double-clicking the objects that are listed, but nothing really happens when selecting an...
I have a Worksheet_SelectionChange event that runs very quickly the first time it is triggered after the file is opened. Selecting a cell brings up a calendar and upon selecting a date in the calendar, some data is processed. Each successive time the macro is triggered, it slows down even...
I have a sheet with records and the rest of the sheet (all the way out to column WXT) has some sort of formating so when I try to get a column count it brings back 16112 columns
instead of the 64 with actual data
My approach is to simply delete the cells in row 1 which lie...
I have a PowerPoint with many slides that have charts linked to data in Excel. Periodically the excel data will be updated - instead of manually going through each slide, selecting each chart, and selecting "Refresh Data", I would like to create a macro that automatically refreshes the data for...
I had password protection added to a workbook so other viewers could not make changes. I removed the protection and re-saved some of the worksheets. Although a password isn't required to open any of the re-saved worksheets, a pop-up appears on opening advising the user that selecting Yes will...
Working in Office 365 I am looking for how to format a table area in my worksheet without having to convert to a table. There used to be options that would allow you to pick preset formatting for your worksheet, but can't locate. I like a format in the Format as a Table, but don't want...
I was sent a workbook that had macros selecting columns of varying length. The debugger showed me it did not like the selection (A1:A)
Once I changed it to (A1:A1000) far more cells than I'll ever populate, the macro works fine.
The question is why does my Office 2016 not like it but many...
I'm trying to select a range in VBA (from cell A2 to M2 down to the bottom of the range of data), but the Sub is going to the bottom of column A instead of selecting the range.
Can someone please clarify why?
I used this code:
I want to use the SUMIFS function to add the values in $AS$1:$AS$2000 based on the criteria_range $A$1:$A$2000 and criterion in cell AZ1.
Rather than selecting the sum_range and criteria_range directly (e.g. by typing in or selecting the range with the mouse) I would like to build these...
The code below sometime works and some other does not. Specially when I change worksheets(1) to worksheets(2) but anyway now it does not work and I have 2 sheets in this workbook. Thank you so much.
Hi, I have a small problem with my range option. I am trying to run mycode and it has to format some precise cells. My code seems to be good but when I run it, instead of selecting the range that I want, my macro is selecting the whole sheets so it detroys what I did previously..