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 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...
sweet that does work.. how come it wont stay? ex. if i then delete the value its looking for and reenter it, it loses its functionality and i have to edit cell and press ctrl+shift+enter again
=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
AH that looks like it could be extremely useful! :) thank you very much i can't wait to try this...
sorry about all that, like i stated on the very, ive had a hell of a time explaining exactly what i need ... i sure i was making it wayyy harder then it is
but thats fine... count it again... we will be reusing these things over and over... if you find "this value" it adds +1 to the count... its now 2 instead of 1 ... then save... the count is now at 2... next time the workbook opens and that macro is run if it finds "this value" add +1 again...
If the macro was run it found "this value" and then changed A1 from 1 to 2 and then was saved... next time it opens that workbook and the macro runs, does it need to know if it ran it before? couldnt it just increase A1 by 1 again and make it 3?
most likely there is something that is needed...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.