Tagged Questions
2
votes
1answer
2k views
Error Finding Last Used cell In VBA [duplicate]
Possible Duplicate:
excel vba row number of last cell with data
when finding last Used cell value using
Dim last_row As Integer
Dim LastRow As Long
LastRow = ...
0
votes
4answers
13k views
Populate unique values in to VBA array from excel
Can any one give me a quick bit of VBA code that will take a range (row or column) from an excel sheet, and populate a list/array with the unique values
i.e.,
table
table
chair
table
stool
stool
...
14
votes
7answers
60k views
How can I find last row that contains data in the excel sheet with a macro?
How can I find the last row that contains data in a specific column and on a specific sheet?
3
votes
4answers
21k views
Copy data from another Workbook through VBA
Guys here's what I want to do and I have a little trouble doing it.
I have 1 Workbook where I want to collect data from different files doing something like this.
Do While ...
13
votes
8answers
59k views
Row number of last cell with data
column A has data like this (ie frequent blank cells):
HEADING <-- this is A1
kfdsl
fdjgnm
fdkj
gdfkj
4353
fdjk <-- this is A9
I would like to be able to get the cell reference of the ...
7
votes
5answers
23k views
vba: get unique values from array
is there built in functionality in vba to get unique values from a one-dimensional array? what about just getting rid of duplicates?
if not, then how would i get the unique values from an array?
5
votes
1answer
3k views
ExecuteExcel4Macro to get value from closed workbook
OK I found this bit of code and thought it might be good to use, if I just need to pull one value from a closed sheet.
strInfoCell = "'" & strPath & "[" & strFile & "]Sheet1'!R3C3"
...
0
votes
5answers
1k views
Excel - VBA Question. Need to access data from all excel files in a directory without opening the files
So I have a "master" excel file that I need to populate with data from excel files in a directory. I just need to access each file and copy one line from the second sheet in each workbook and paste ...
20
votes
5answers
41k views
Macro to save each sheet in an Excel workbook to separate CSV files
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
I have an excel with multiple sheets and I was looking for a macro that will save each sheet to a separate CSV (comma ...
2
votes
5answers
7k views
What is the best way to master VBA macros for MS Office applications? [closed]
I am working in a farm that requires me to do lots of MS Office application work. I want to automate all these tasks using VBA macros. So, I want to master the skill sets to write VBA macros for MS ...
5
votes
3answers
1k views
How to extract and plot only minimal and maximal peaks of an array , -graph analysis- With Matlab or excel
so i'm doing video analysis.
The end result array i get is something like that
signal =
Columns 1 through 7
73960 73960 73960 73960 68102 68102 68102
...
4
votes
3answers
35k views
How do I use FileSystemObject in VBA?
Is there something that I need to reference? How do I use this:
Dim fso As New FileSystemObject
Dim fld As Folder
Dim ts As TextStream
I am getting an error because it does not recognize these ...
3
votes
1answer
1k views
Repeating MS Word macro until no search results found
I've created a MS Word macro that searches for certain text (indicated by markup codes), cuts the text and inserts it into a new footnote, and then deletes the markup codes from the footnote. Now I ...
0
votes
2answers
2k views
running multiple macros in order across multiple excel workbooks - vba
I have multiple excel workbooks each representing a days data, each workbook has multiple sheets representing each event on the day..
i need to run 6 macros in order across each sheet in a workbook ...
13
votes
9answers
42k views
How to check for empty array in vba macro
I want to check for empty arrays. Google gave me varied solutions but nothing worked. Maybe I am not applying them correctly.
Function GetBoiler(ByVal sFile As String) As String
'Email Signature
...
