Description:
Microsoft Office Excel newsgroup.
|
|
|
name a range from the current activecell down 12 rows
|
| |
Hi, I know this is probably very simple but I can't find the code i need and when I try to record as a macro i get hard coded addesses (c7.c19) rather then just something like "xldown 12." and since the starting address varies, the hardcoded address don't help. I want to select the activecell and 12 or 13 down and then give that range a name. Thk in... more »
|
|
|
Data Validation drop-down
|
| |
I have a cell with data validation drop-down in it. If I've already chosen an item the list opens next time with tht item at the top of the list - can't see the ones at the top unless I scroll up. I want it to open showing the beginning of the list each time. Can I control how it opens? I am OK with a VBA solution if that's the only way to do it, too. but how... more »
|
|
|
Regular Expression Help on syntax
|
| |
Need help on regular expression, where we are trying to grab number values as well as minus sign if negative. Currently we can grab all the numbers correctly, just if numbers are negative, we only grab the number not the number and the minus sign: Example for: -10 we get 10 but want -10 of course... more »
|
|
|
Count numbers that start with 1
|
| |
Hi, Is it possible to search a spreadsheet and count the numbers that only start with the number 1? And then also count how many cells it searched in order to obtain that value? For Example: 10 2,100 1,500,100 10,150,280 317 Cells with the number 1 = 3 Total cells looked at = 5 Thanks!
|
|
|
Pivot Tables - How to display multiple items?
|
| |
Hi, I was windering if some one could provide me with a link to a tutorial for what I am trying to do. I have an aggregate table. This table has several groups and several columns. The intersection of a group and column is an aggreate value such as Sum function of a column value in that group. Normally a Pivot table shows 1 aggregate value at the intersection of a... more »
|
|
|
macro recording
|
| |
Hi. When I record a macro,and move to the last cell in a worksheet, the recorded command is correct as: ActiveCell.SpecialCells(xlLast Cell).Select However, I then wish to move to the first cell in that last row by way of the macro but the move gets recorded as an absolute cell reference. That won't work later when the table size changes.... more »
|
|
|
Scroll when importing data
|
| |
Excel 2007 I have a VBA-routine that imports data from an external source. There will be hundreds of rows imported, and this takes several minutes to complete. I would like to always have the last imported row visible. As it is now the page does not scroll as the import takes place. Does anyone understand what I am after, and does anyone have a solution? I... more »
|
|
|
Excel export to Access - Run-time error 1004
|
| |
I have Office 2003 and would like to export cell contents to an Access table I've created using an Excel worksheet button. The code below works when there are only 14 cells but bigger than that I get "method range of object worksheet failed. Run-time error 1004." arrrg. Private Sub CommandButton5_DblClick(ByVal Cancel As MSForms.ReturnBoolean)... more »
|
|
|
Copy/Paste Excel Macro
|
| |
Hello, What I'm trying to do is automate a process using an excel macro. What I need the macro to do is to look for a blank cell in a range of data in Column A, and whenever there is a blank space within that range, paste some specific above information into this row. (I'm formatting an excel file after taking it from another program). I would greatly... more »
|
|
|
Open Files in Folder
|
| |
Hi I have been using this code to open all XL files in a certain directory. Works well sometimes but if I am in Excel and go to File - Open and change the directory to a completly different drive the Dir function remembers this drive rather than the one I am telling it. What can I do to force the Dir to always look at my specific... more »
|
|
|
|
