Hello I'm in need of help.
Right here is the back story,
I'm currently away with the United Nations and a apart of my job is to search peoples names and registration before they enter the base. At the moment we have to search over 500 peoples names on a sheet of paper...
I've made an excel...
Hello I'm in need of help.
Right here is the back story,
I'm currently away with the United Nations and a apart of my job is to search peoples names and registration before they enter the base. At the moment we have to search over 500 peoples names on a sheet of paper...
I've made an excel...
I will admit I am not a excel savvy person, so I could really use some help. Currently all of my inventory is saved to an excel 2010 spreadsheet, about 162 items. Each item has an ID number & description. Also on the spreadsheet are the quantities in my 2 locations and lastly the unit of measure...
Hi everyone,
I am trying to transfer Excel data to a password protected Access 2010 database. So far I have the following code that works perfectly if the database is unprotected (minus the JET OLEDB Password part)
Dim MyConnXLS As String
Dim MyConnADODB As String
Dim MyConn As New...
Good day,
I need to submit a piece of work today, however every time I click on a check box a popup appears:
"Cannot run the macro "Filename'!CheckBox1_Click'. The macro may not be available in this workbook or all macros may be disabled."
I was trying to clean up any macros that I was not...
Hi, just one more question... For this codes: The one which is highlighted in red, how can I make it to dynamic range too?
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Residential Raw!R1C1:R659C34", Version:=xlPivotTableVersion14). _...
Hi! This is the codes which I'm currently working on. Just wondering how can I make the range (highlighted in red) into dynamic range such that all the data will be captured no matter the number of rows there are.
ActiveSheet.Range("$A$1:$AH$995").AutoFilter Field:=21, Criteria1:="=FH*"...
Hi All:
I'm trying to copy data from one sheet to another. The following code is working but the problem is that it only copies the first line and it does not select any other breached or warning ticket(see attachment) If you open the sheet the code won't work because I set the Range to...
I've been working on a userform at my house. All I have done so far is the userform1 page design and a button on the excel spreadsheet itself to run the macro.
On my laptop and my desktop at home, they work just fine.
But on my work computer(s), they bring up the Error 2110. I'm not sure how...
I did this 10 years ago so I admit I am rusty at this but here are what I had in my notes that worked with Excel XP. I am currently using Excel 2010
With ThisWorkbook
.HasRoutingSlip = True
With .RoutingSlip
.Delivery = xlOneAfterAnother
.Recipients =...
Hi Guys.,
I got stuck into a problem while using Macros. I would like to find the difference of two values in the same column if the particular criteria matches..
Actually i was trying in Excel using the formula =IF(($V$2=V3)=TRUE,J3-$J$2,"").
Could some one hlep me with macros program as I'm...
Learning VBA on the job, I'm not able to get the following code to work. Would appreciate some support. I receive Runtime error '91' at Line 6
Dim xlApp As New Excel.Application
Dim xlBook As Excel.WorkBook
Dim xlSheet As Excel.WorkSheet
Dim FoundCell As Range
xlApp.WorkBooks.Open...
Hi
I need to save single sheet from workbook (sheet7) as text file in specific folder (c:\Test) if the file exists a warning should show if you would like to over-write the file. And et the end change file extension from .txt to .dat
Thanks
Zibi
Hi
I have timesheet spreadsheet application,and this spreadsheet require to add new sheets for new employee using vba
iam adding new sheets by copying sheets("sample") for every new employee,and this sheet("sample") contains Named ranges with scope to workbook,but the problem is :
every new...
Hi ...
i have Myspreadsheet.xlsb then i converted to Myspreadsheet.exe .
so when i want copy sheet from :
Source: Myspreadsheet.xlsb to
Destination: Myspreadsheet.exe
i faced the source dont see the Dest. as open workbook ,so what shall i do with this ,and can i know from expert why...
<COLGROUP><COL style="WIDTH: 48pt" span=26 width=64><TBODY>
1007A1
VTC
VLB9
a
b
c
d
g
h
i
j
k
2011
0
0
0
0
0
0
0
0
0
0
0
0
</TBODY>
Hi i need the above sheet to be converted into following format in another sheet:confused:
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
1007A1
VTC...
I create workbooks that have a significant amount of private data that is used to generate charts and reports. We want to distribute a workbook with just the charts and reports without any links to the data. No big deal - use vba - create a new workbook, copy over the charts to the new workbook...
Hi Guys,
I am trying to close my active window without saving, using (SaveChange = False)
and I receive a compile error stating 'Cant find project or library' I am using Excel 2010 and it was working before the upgrade, any ideas?! Full Code below and thanks for your help in advance! :eeek...
why do i get "range out of bounds" for v(i) = x(i) * y(i)?
Function element_mul(x, y)
Dim i As Long
Dim v()
ReDim v(1 To size(x))
For i = LBound(x) To UBound(x)
**v(i) = x(i) * y(i)**
Next
element_mul = v
End Function
Sub main_ols()
Dim x, y...
hey, i'm creating a database on excel and i've come across a problem, on sheet "database" i have data starting from b2-e2, headed, reference number, product name, description , date respectivley there is data underneath and keeps adding. what i need is a macro code to do the following, i want...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.