tmp

SOS, hoping someone can provide assistance to this challenge I have failed to overcome. I require to identify specific text nestled between the character 'OR' from a string Example; Cell A2 = OR Apprentice OR Assistant OR Professional OR Trainee OR Answer; Cell B2 = Apprentice Cell C2 =...

Hi I am 100% certain that something in the below code is causing my worksheet to hang when I double click on a cell or when I run a macro affecting this sheet - there are NO VBA errors. Unfortunately the code was written for me around 15 years ago, so I can't go back to the author to query it...

Hi all, I'm a little stuck. I have a spreadsheet which I am going to use to generate some values which then need to be appended to the first blank row in an existing .csv file. This is what I have so far: Sub Append2CSV() Dim tmpCSV As String 'string to hold the CSV info Dim f As Integer...

Hi I wrote a code to swap 2 cells. Can I swap 2 selected cells/ranges instead of hard coding the way I did it. Thank you so much Sub myswab() Dim tmp As Double tmp = Range("a1").Value Range("a1").Value = Range("b1").Value Range("b1").Value = tmp End Sub

I feel like I am pretty good at VBA, but, I have always struggled with wrapping my head around recursion. I banged my head against the wall for hours this morning trying to figure this out. I got the code to work, but I am sure there must be a better way to do it. I would like to get better...

Hi guys, how do I change this macro so that it outputs to an excel sheet (column A and column B). Sub GetUniqueAndCount() Dim d As Object, c As Range, k, tmp As String Set d = CreateObject("scripting.dictionary") For Each c In Selection tmp = Trim(c.Value) If...

I have code to export / copy sheets to a new workbook. The issue is, some of the color formatting is missing. Can someone help answer why? Sub Report6Export() Dim Fname As String, ws As Worksheet Dim Ary As Variant, tmp As Variant Dim i As Long Fname = "Review - " &...

Hi All I want to change the color of the alternate rows starting from A3, but with unknown number of columns and rows. I have found the code below but I don't know how to apply to an unknown range, please could I have some advice? Dim r As Range Set r = Range("A3:A20") Dim tmp As...

Hello everyone, I need help with modifying the VBA code below: I want to change the line of code below. Select Case Right(SumDigits(CStr(a(i, j))), 1) + 0 Is it possible to create a new line of code. For example, In cell A1 I have the number 123 I would like to format a "custom" cell...

I am having an issue with Excel 2013 crashing where I have a master file that generates a new workbook from selected sheets from the master file. the scenario is I create the new workbook with the selected or grouped sheets from the master file, it saves and closes the new workbook...

Hi, I am a herbal medicine practioner, I made a excel program to help me in my trade. I need some help from excel vba masters that how can I do vba coding for following: 1) Sheet1 col A and B <colgroup><col><col></colgroup><tbody> Medicine Tmp No Mohrak 1 Molyen 5 Shadeed 1 Molyen 1...

Hi, I have an excel macro template. I wrote a VBscript to call upon that excel and run those macros. Each time I run the VBscript - after it ended it would leave a TMP file in the destination folder and create a cluster in the folder. What should I do so that after I run the script, it won't...

hey guys, for my job we have a bunch of account info (on separate lines) with names for each account consolidated into 1 cell (example: A1 = ANNE ARUNDEL COUNTY RETIREMENT SYSTEM). <tbody> were doing a data merge and the field in our system only fits 35 characters. we would like to split the...

Hi Everyone Sub OpenLon() StoreName = "Londonf" On Error Resume Next Kill "S:\" & StoreName & "\New Documents Folder\*.TMP" On Error GoTo 0 End Sub The above code works great for removing TMP files from "New Document Folder" Is there a way I could get it to run on all folders in "S:"...