subsequent

Normally I use the "'" apostrophe to keep the "0" at the start of a string of numbers, but I am impurting the sheet into an excel tool which is dropping the ' and the subsequent "0". Is there another way to keep the "0" in the string. Thank you, Jerry

I'm trying to automate the processing of several files, and several of the files throw up the message: "We found a problem with some content in 'ThisFile.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes." In order to get around this...

Please help! This is my first time posting. Please excuse me, if I'm not clear enough. I'm trying to figure out a way to number the rows as in Col C below. The first instance of Col A should be numbered 1, if subsequent value is same as Col B then 1 or increment 1. Thanks <tbody>...

Option Explicit Dim fileloc As Long fileloc = "G:\Infection Control\CDRNE\CDRN Prism Data\MLVA data\IC RAW EXPORT TABLE" I want t use this fileloc string in several subsequent modules but I get an error message Compile error Invalid outside procedure Any ideas please

I want to return the column headings for each x in a record (row) I can find the first using index and match but not subsequent column headings. <tbody> ad ae af ag ah edu charity aa data frce x x </tbody>

I want to write a function where the first argument is mandatory (the year) but subsequent arguments vary from no arguments to as many as entered. Is that possible? I don't want to write: Public Function MyFn(Year, Optional Loc1, Optional Loc2, Optional Loc3, Optional Loc4, Optional Loc5...

I would like to define a range value like "A1" to the variable RngEnd2. EndDate is a string value . The purpose for setting RngEnd2 is to use it as a range value in a subsequent statement. Set RngEnd2 = Cells.Find(What:=EndDate, After:=ActiveCell, LookIn:=xlFormulas, _...

I'm working on a report with thousands of entries. For some reason, the report only returns data in column C the first time a value appears in column B, for all subsequent entries of that value(B), Column C remains empty. I need to locate all duplicate values in column B, and copy the value of...