Recent content by xxentric

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 =...

ah thank you, that would be a good way to do it too, ill have to keep that handy. thanks!

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 ??

AH! thank you, just needed that and the tripple quotes on the file path and it works great

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

O_o .... i may have to give up for now... this is drivin me crazy, i dunno why nothing is working out WorkBook1 user enters " 12-1 " in cell A1 runs macro. macro opens WorkBook2, and looks for " 12-1 " in column A and when found (say it's located in A8) adds +1 to whatever number is in B8...

well this is what i tried to use... but its just going crazy on me lol... i mean this is returning a value of 12 ... yet there isn't even anything in the cells in the other workbook =COUNT(IF('C:\Users\FAM7\Desktop\Jared FC Project\[test.xls]Sheet1'!$A$1:$A$12="12-8",1,0))

yea those are my posts before... typically i know what i need and can find examples close enough to figure it out myself... but for this particular problem i couldnt find examples of what i needed even though to me what i wanted it to do seemed simple enough, i couldnt find how to do it... so...

well the last time i asked i was linked to another forum by someone and they are trying to have me use the regular CountIf function... but that method is really not working for me... the problem is there are alot values that need to be checked for, and im not sure the best way to go about this...

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...