Here is what I came up with. The macro will color the text in the cell white or black depending...
Please try this as well. Sub Save2PDF() Dim Fname As String Fname = InputBox("Enter file name to save", "Save as...
Here is a simple copy and paste from cell A1 to D1 using vba Sub cpy() Range("A1").Copy Destination:=Range("C1") End Sub
I did not write this code but I think that it may help you. For more information about this code...
Hello Can you upload sample of your workbook?
Hi, Thanks for the reply. I need to find a formula for finding the column number, i can't give a...
Not sure if this will help. When you save your file click Tools>General Options and then click on Always create...
Sheet1 column "A" must have at least 2 rows (Cells A1 and A2) of data for macro to work. Less...
You are awesome, it works perfectly. Only issue is that the Date format in the Output Sheet is coming in as “Custom” instead of “Date” because of which this needs to be modified manually.
Hi Yaseer here is the link https://we.tl/8R9kqh99SX
Unable to attach the excel sheet, do I need to subscribe to something before I do it? I don’t mind doing that as well. Please let me know
Valli sir-when I run this macro nothing seems to be happening, am I missing something. I would want the macro to search for rows with Workday and wherever there are multiple states, copy them in separate rows either on Sheet 1 or Sheet 2 as separate entries.
Can I populate different values in this template for multiple users. To explain this further if I create a datasheet and have multiple sheets to be created using the data. Something like a mail merge in excel, how do i modify this code
Thank you for your help as also, much appreciated.
Thank you tried this, somehow not working. I am sure I am missing something on execution? My question is should i insert this code in the USERFORM by double clicking.
Thank you, this works perfectly fine.
I need help in having each text file with a unique name. How do I modify my VB code. It will be a great help
Need help in fixing this macro. I would like to pull historical fx rates from this URL and save it in excel:-
‘ CrawlWeb Macro
‘ With ActiveSheet.QueryTables.Add(Connection:= “URL;http://x-rates.com/historical/?from=USD&amount=1&date=Name”,Destination:=Range(“$A$1”)).CommandType = 0
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = “2”
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False