Search results for query: *

the code im working with below wont work becuase it is telling me "'text' is not a member of 'string'" how would i go about doing this ** i have 15 text boxes on this form labeled fix1 - fix15, which is why im trying to do this instead of repeating code for each item Public Fix(0 To...

(i think i may have posted this in the wrong forum before) i have just a loop code here as an example of how im filling data down a column... how could i do this the other way and have it fill the data across a row instead? Do While myRecSet.EOF = False myRecipe(i) =...

i have just a loop code here as an example of how im filling data down a column... how could i do this the other way and have it fill the data across a row instead? Do While myRecSet.EOF = False myRecipe(i) = CStr(myRecSet.Fields(0).Value) ThisWorkbook.Worksheets("Sheet1").Range("A" &...

im not sure how to go about this macro really... if i would have conditional formatting in cells A4 B4 C4 and i wanted to copy that conditional formatting into a certain number of rows below (like an auto-fill) determined by what the user enter in cell A1... so say in A1 the user enters "6"...

im not sure why im getting this failure on deleting the row... i have looked at some examples of this. here is the code... Dim lookForRng As Range Dim lookFor As Range Dim rng As Range Dim found Set lookForRng = ThisWorkbook.Sheets("Sheet2").Range("C3") Set rng =...

If i have info in excel formatted as text the info looks like this 12-1 or 10-2 it needs to be formatted as text so it is displayed like that, otherwise by default it turns into a date.... im having an issue here where if i use the code below to that that info as a csv file, in the csv it...

Is it possible to use conditional formatting to to turn a cell red whenever the value in the cell is divisible by 10 ??

is there something extra i need for this code? im getting an object required error Dim WshShell As String Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run "C:\Documents and Settings\chipfab\Desktop\Jared FC Project\Search Script OverwriteVBS.vbs", 1, True

im tryign to find a macro that will look in another workbook for value "A" on range A1:A12 and if it finds the value adds +1 to whatever number is already in cell B4 of "ThisWorkbook" so in cell b4 of Thisworkbook there is a value of 5 macro searches C:\drive\test.xls for "A" in A1:A12 if...

=SUM(IF('C:\Documents and Settings\chipfab\Desktop\[test.xls]Sheet1'!$A$1:$A$9="12-1",1,0)) why will this only work if the value is in A1 ??? if its in A5 it returns 0 or false

ok... lets try this forum... i seem to be having trouble explaining what i need. I have a workbook "book1" where users will be entering ID's of containers. when they enter it will look like so 12-1 15-5 30-2... and so on (12 maximum for now) I have another workbook "book2" that im trying to...

ok... lets try this forum... i seem to be having trouble explaining what i need. I have a workbook "book1" where users will be entering ID's of containers. when they enter it will look like so 12-1 15-5 30-2... and so on (12 maximum for now) I have another workbook "book2" that im trying to...

I have 2 workbooks, book1 and book2 If book1 has a macro that will ... 1. open book2 2. copy and paste cells from book1 to book2 3. then close book 2 Is there a way to change it so that before closing book2 it will save book2 as whatever value is in book1's cell A5 ?

I'm not sure whats wrong with this code.. but its not opening a file, when i run it, i do not get any errors, but nothing happens... i have checked the file names to make sure it matches the code, but still nothing Option Explicit Const ForReading = 1 Const ForWriting = 2 Dim objFSO...