excel-2007 Questions
3
I have a problem in VBA with a line throwing back an error.
What the macro is intended to do is find a particular cell then paste data into it.
The code is as following:
'To find Column of Cust...
Stratify asked 15/12, 2013 at 23:13
9
Solved
Does anybody know if it is possible to show numbers in MS Excel with SI-prefixes?
I'd like to have
... 1 n, 1 µ, 1 m, 1, 1 k, 1M, 1 G, ...
instead of scientific format
... 1E-09, 1E-06, 1E-03...
Jernigan asked 24/9, 2013 at 21:5
11
I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "Microsoft.ACE.OLEDB.12.0" OLE DB provider, and I'm getting a persistent "C...
Deposit asked 10/1, 2012 at 2:48
3
Solved
I tried char(10) and char(13) but they don`t work by me. I use Excel 2007 and my task is to replace new lines with intervals
Asdic asked 18/12, 2015 at 16:11
4
Solved
How can i refer to the object i use inside With if i want the object itself, not its properties / methods?
With ThisWorkbook.Sheets("MySheet")
Call MySub(ThisWorkbook.Sheets("MySheet")) ' works O...
Crave asked 29/6, 2012 at 17:29
26
Solved
I'm working on a feature to export search results to a CSV file to be opened in Excel. One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. In order to co...
Grassi asked 19/4, 2010 at 15:31
2
Solved
I've had a search around for this but havn't found anything yet. To clarify, I'm looking for a simple if statement for applying an autofilter if none exists, or do nothing if there is one already i...
Slatternly asked 10/4, 2015 at 15:32
25
I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in ...
Pending asked 7/4, 2010 at 20:30
11
Solved
I have names in a column. I need to split just the last names from that column into another column.
The last name is delimited by a space from the right side.
The contents in cell A2 = Alistair Ste...
Ginsberg asked 26/5, 2011 at 3:11
4
Solved
So I have a simple little macro/sub defined when a command button is clicked. The problem is it gives me:
Run Time Error '91' : Object Variable or With Block not Set
My code is:
Dim rng As Range
rn...
Serious asked 12/3, 2011 at 9:44
6
System Out of Memory Exception. I see the memory Stream is only flushed when saved. We have 1.5 - 2GB Datasets.
I am using EPPlus Version 3.1.3.0
We do the following in code.
We loop through
...
Madelaine asked 6/11, 2014 at 19:5
11
Solved
Just recently I've been trying to delete all data rows in a table, apart from the first (which needs to just be cleared)
Some of the tables being actioned could already have no rows, so I was runn...
Hedi asked 18/12, 2013 at 16:33
4
Solved
I've got a large table of data in an Excel spreadsheet that, essentially, can be considered to be a collection of values for individuals identified as belonging to various subpopulations:
IndivID...
Penguin asked 18/11, 2012 at 14:32
12
Solved
Ok, so you know what a spreadsheet looks like when you open a new on in Excel; the borders are a light blue. These are only on the screen though, if you print the sheet it will not have borders. Sa...
Sabian asked 10/2, 2011 at 5:40
4
There are plenty of formula-based solutions for finding the last non-empty cell value from a column, row or continuous range in Excel, for example, for columns the most popular are =LOOKUP(2,1/(A:A...
Soupy asked 26/4, 2023 at 16:27
4
Solved
How can i unprotect my VB project from a vb macro ?
i have found this code:
Sub UnprotectVBProject(ByRef WB As Workbook, ByVal Password As String)
Dim VBProj As Object
Set VBProj = WB.VBProject...
Dapplegray asked 23/4, 2013 at 16:24
4
Solved
Thanks to Siddharth Rout at this Post I learned how to save a sheet to a new Worksheet. Now my question is how I can add Date and Time of file creation like:
TestSheet_25May2013_5pm.xls
Sub Sa...
Ansilme asked 17/12, 2013 at 13:36
11
I am trying to use VBA to automate the Change Picture function when you right click a Shape in Excel/Word/Powerpoint.
However, I am not able to find any reference, can you assist?
Dominant asked 16/4, 2012 at 5:16
5
Solved
I have a column where people enter email address manually. I want to validate the email address using this formula:
=AND(FIND(“@”,A2),FIND(“.”,A2),ISERROR(FIND(” “,A2)))
but excel comes up with ...
Goosander asked 23/1, 2013 at 14:45
8
Solved
I have 8 variables in column A, 1,2,3,4,5 and A, B, C.
My aim is to filter out A, B, C and display only 1-5.
I can do this using the following code:
My_Range.AutoFilter Field:=1, Criteria1:=Array...
Samarium asked 18/2, 2015 at 4:3
3
Solved
I'm using the Apache POI to generate an Excel File (2007). What I want is to protect the sheet, but with some options enabled. By options I mean the check box list when you try to protect the sheet...
Ronnyronsard asked 5/2, 2013 at 6:17
5
Solved
Let's say that I've got a sheet - number one - with over 5000 rows (say, columns 'A' - 'H' each).
In another sheet - number two - I have a "to-remove-list" - a single column 'A' with 400 values, e...
Hawkinson asked 12/9, 2012 at 17:33
10
Solved
I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I regularly have work...
Lionellionello asked 4/9, 2012 at 20:30
12
Solved
How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end.
Example:
[email protected] turns into [email protected],
Data Sample:
[email pr...
Embryotomy asked 5/7, 2010 at 12:42
9
Solved
I created a sheet with merged cells, but the value of the merged cells is only stored in the first cell. Is there anyway, to keep the same value in each of the cells, I need that for a formula I us...
Quartis asked 24/6, 2011 at 6:34
1 Next >
© 2022 - 2025 — McMap. All rights reserved.