Hello, I'm having an issue and I can't find a simple solution.
I have (2) UserForms that each fill tables in two separate sheets. Problem is, I want to run the forms from a Dashboard and the forms only fills cells on the sheet I'm active on.
I need UF1 to fill sheet2 and UF2 to fill sheet3 all...
Hi,
i made a macro by clicking the cell and inserting a picture image. But, the vba range and the sheet range doesn't match.
ex. i want to insert a picture in cell b6 but it seems the picture inserts in between b5 and b6.
this is my code below
Private Sub Worksheet_BeforeDoubleClick(ByVal...
Good Afternoon everyone!
I need help a macro that increments correctly.
The macro i'm trying to tweak is meant to copy the activesheet, and paste the duplicate with the old name and the revision number.
i.e.: ORC01 to ORC01_R1
since this macro is applied to a button on the activesheet, it...
Hi all!
I want to automatically check a number of files whether their column numbers corresponds to the number of columns of another sheet.
I have tried to solve that like this:
Workbooks.Open Filename:=Path2 & NewList(o), ReadOnly:=True, UpdateLinks:=False
For Each Sheet In...
Hi, Recently I have Office 365 and also SharePoint with the new "Team Sites" environment (previously called workgroups). Anyhow, I have a macro which convert the excel sheet into pdf and puts this pdf in an email ready to send.
This is the coding :
sub sendPDF()
Dim OutlookApp As Object...
Hi,
Straight to the point but here is the code
stADO = "Provider=SQLOLEDB;Data Source=UKD1-ENG-01;Initial Catalog=" & ActiveSheet.Name & "WWALMDB;User ID=SA;Password=*****"
Basically this works, however instead of it pulling from: (sheet name)WWALMDB i would like it to pull from...
I have this code and its not working, can anyone explain to me why?
sub test()
Dim lastCol As Long
with activesheet
lastCol = .Range("A1").SpecialCells(xlCellTypeLastCell).Column
Columns(17 & ":" & lastCol).Delete Shift:=xlToLeft
end with
or
sub test()
Dim lastCol As Long
with...
Hi, I think this is a simple question but I can't figure it out. I'm using this code to refresh a pivot if data on a worksheet is changed but it's refreshing all pivots rather than just the pivots on the active worksheet. Where I'm running into issues is that I dont want to have to specify the...
Hello, everyone!
I am new to VBA,nice to meet you.
I have the following application plan:
1) there is Diagramme sheet on index number1 for visual Evaluation of processig data.
2) there is a "to be shown in sheet 1" sheet as data Input on sheet with index number2
3) the following Sheets are raw...
I have some simple code that has worked for many years to fix the used range within a sheet after deleting a bunch of rows. Now it doesn't seem to work anymore. It was working through Excel 2013 but now that I'm using Excel 365, it has stopped working.
Sub FixUsedRange()
If...
Hi
Using Object browser, Application class has the following:
Activecell as range
Activechart as chart
Activesheet as object
Activeworkbook as workbook
ActiveWindow as winodw
All of them make sense to me except ActiveSheet? Why is define as Object? What does that mean? Why they did not...
Hi
Excel defines ActiveSheet as following: (using object browser)
property Activesheet as Object
Read only
Member of Excel Application
My question, what does object means here? I thought the correct definition should be
Activesheet as Worksheet
Thank you very much.
Hi Guys,
I have a macro that inserts rows in a workbook and is applied to all worksheets, this works great but I am trying to modify it to only work on the open worksheet (i am supposing this is activesheet) but it keeps failing.
The code that is working on all the sheets is as follows
Sub...
Hi Guys,
I have recorded a macro to create a table which works fine but i'm wondering if there is a way to change the range so it looks to the last row in column P rather than the selected range. Hope this makes sense.
Thanks
Sub CREATE()
Sheets("Bethan").Select
Range(Selection...
Hi,
I asked a question last week about filtering out a number of items in a list. However, the sheet that is used for this prois set to the Activesheet:
/[code]
'master sheet
Set ws1Master = ActiveSheet ' --> Can this be changed to a new created sheet?
[code]/
I am running a series...
Hi All,
I have some code running on my computer that is operating fine, but on another guy's computer, it gets hung up. on the Worksheet Change, I have this code (partial):
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Application.EnableEvents = False...
Hi, I'm trying to prevent xps overwrite on save.
I can't get anything to work. I'd prefer to use a variable value to individualize each save.
Is it even possible?
With ActiveSheet
.ExportAsFixedFormat _
Type:=xlTypeXPS, _...
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.