Hi and Thanks in advance
i have post earlier some problem and get the solution but that was in complete and also i have lost that post url.
Problem is, i have following sheet
In the above...
Thanks in advance
I want to know that from the given
(Query-1) numbers 0,1,2,3,4,5,6,7
(Query-2) numbers 1,2,3,4,5,6,7,8
how many combination we can generate without repetition and if possible pls provide the generated combination.
i am using this code but want to few changes, please help
Private Sub CommandButton1_Click()
a = Worksheets(“Sheet1”) .Cells(Rows.Count, 1) .End(x1Up) .Row
For I = 2 To a
If Worksheets (“Sheet1”) .Cells(I, 3) .Value = “North” Then
Worksheets (“Sheet1”) .Rows(i) .Copy...
pls provide code or formula for a sheet
link is https://drive.google.com/file/d/1PS_zvcTpLhqOpa6uclRsh0O-IS0Hvveg/view?usp=sharing
you can check the file so that all the points will be clear
we need two results
1. After how many rows the digit comes
2. Highlight the cell when the value comes...
I've got the below code running in my dashboard tab:
If Range("A1").Value = "1" Then
ActiveSheet.ChartObjects("Chart 3").Visible = False
ActiveSheet.ChartObjects("Chart 1").Visible = False...
I have current code to change the background of the cell I updated "Today" to the color of the day. Today is the 15th of the month, so todays color is 15. What I am looking for is the "15" to change based on the day, so tomorrow the code would change to 16 without me going into the code daily...
Hi guys, saw something weird today. I wrote code that goes into my network at work and grabs a file from a specified folder for our current month "03 - Mar" and does a copy paste to another report. The issue that I saw today is that if another user runs the file the macro is grabbing the file...
Hello, I have an excel sheet with several columns.Each column stands for specific historical data.
I would like to search in the excel sheetover a search field (command button).
A reset command button is planned toreset the sheet after every search and to empty the search field (commandbutton)...
Need help modifying the code below to meet my requirements.
Instead of having the InputBox prompt for Vendor No & Vendor Name and then saving to C:/. I would like to code to automatically use the file name I am converting into .CIF and store to a specified folder.
Also, need the bottom part...
I currently have a worksheet that will populate days with the initials of the Staff that has been assigned a task that begins and ends in a certain time frame. I've used an IF function for this.
I now have another task I must do. My boss wants there to be an Error Message...
Is there a way to combine data from multiple excel files into one single sheet by appending data? All the files have the same headers. Also these sheets have drop down list and conditional formatting. Is it possible to append the original data with all the conditional formatting...
I have a bit of a complex problem that i have been having trouble fixing.
We currently perform alot of data entry and i would like this macro to avoid doing it manually. We recieve a list from our client and in column A is a list of their clients. I need the macro to verify as close a match as...
I am using the following code to calculate the Balance from the data, Balance = Demand - collection
Dim c As Range
Dim lRow As Long
lRow = 1
Dim lRowLast As Long
Dim lRowDiff As Long
Dim lRowPortion As Long
lRowPortion = 1
Dim bFoundCollection As Boolean
A newbie to VB coding here. I have a small piece of code that has me stumped. I am using Excel 2012. The purchase of the code is to allow the user to enter one Ticker symbol that resides in two Excel sheets. Each sheet has the ticker symbol in column A, date in col B, formula in column C, and...
please use the version1.7 to add the vb formula in it.
in modmain vb script
i need to add a vb code in by vb script below
1.data is in c1 out put to c3.,after first 2 digits the following 4 digits
2. data in c9, and c16 ,“open and Closed inverted...
I pull weekly alarm reports. Each alarm has a different "Process States". The states include: active, inactive, completed and pending. I only need to see the "Active" alarms.
The Process State is in column J.
The raw report looks like this. The report is anywhere from 40,0000 to 60,0000...
I have five worksheets hidden in my workbook. All of these worksheets have either "Yes" or "No" written in cell C4. (3-yes, 2-no)
I also have a search bar in the form of a textbox and a command button.
I want to be able to type "No" in the textbox, click the command button and have the pages...
Is there a way to send the VB code for buttons and macros with the spreadsheet when emailing from within excel? I have a button to send a spreadsheet through outlook, but when the file arrives at recipient the code and macro are not there.
I've searched to try and find the answer to this question but not having much joy so any help will be greatly appreciated.
I'm relartively new to excel VB codes and my seemingly impossible task is shown below:
* I have a list of data each one has 6 rows of data.
I have this code on multiple modules:
'---Get Short Filename cShortFileName = GetFileName(aSelections(General.nReqNo, 4))
'---Check for a trailing period and xls
cShortFileName = GetShortFileName(cShortFileName)
'---Set Page Setup and Print Area