hi,
I am new to VBA and tryin to reduce some workload to make a small VBA program to copy range randomly with mouse and paste it to destination file.
source file is "Mytest.xlsm" and destination file is "BatchEntry.xlsx"
I can easily copy range by below code and successfully paste It to other...
Hi,
I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...
hi,
I have listbox. When user select item and click add, the value should be add to sheet: one row below where the current field is selected.
'Set addme = 'missing code
For x = 0 To Me.lbsourceList.ListCount - 1
If Me.lbsourceList.Selected(x) Then...
Hello - I am trying to figure out how to run a code based on multiple cells selected by mouse.
I have been trying some basics to figure it out with no success:
Sub Color_Green()
Application.ScreenUpdating = False
Dim Ac As Range
Dim a, b As Long
With ActiveSheet
Set Ac.Range =...
Hey Guys,
im using macro coding and trying to use a defined set of values in a code.
so i selected a set of values and defined the name as expansion and this is how i wrote the code
Sub Hide_cells()
'
' Hide_cells Macro
'
'...
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.