Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Macro to modify the fomular in highlighted Excel cells?
Wow, Brad, looks great. Why did you neglect constants? Would it be hard to have this work on them too, because I would like it to be able to. Could we add something like: else cel.Formula = "=ROUNDDOWN(" & IDunnoWhatToPutHere & "," & i & ")- jtb1492
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro to modify the fomular in highlighted Excel cells?
I want to add the text "rounddown(" to the beginning and the text ",3)" to the end of the current formula in the cell (no quotes obviosly), for every cell I have highlighted, no matter what the current formula in the cell is.- jtb1492
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro to modify the fomular in highlighted Excel cells?
In plain english, I want to take the fomula in a call and modify it by adding text the to beginning and end, for every cell I have highlighted.- jtb1492
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro to modify the fomular in highlighted Excel cells?
...the cell and not just entering what I change it do. The is what the recorder gives me, which is pretty much useless: Sub Macro1() ActiveCell.FormulaR1C1 = "=ROUNDDOWN(3.12545,2)" Range("E8").Select ActiveCell.FormulaR1C1 = "=ROUNDDOWN(R[-3]C*R[-2]C,3)" Range("E9").Select End Sub- jtb1492
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro to modify the fomular in highlighted Excel cells?
I need to write a macro that will modify the fomula in the highlighted cells. Cell B2: =4.325112 Cell C2: =A1*A2 I'd like to highlight cells B2 and C2 run the macro, the macro asks me to input an integer, and then the forumals in the highlighted range are modified as follows: Cell B2...- jtb1492
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I create a variable whose name depends on the value of another?
I'd like to have a array with names in it, like 'Blue' and 'White' and 'Green'. Then I want to be able to create scalar variables from within some loops like: $AWhiteBig $BWhiteBig $AWhiteSmall $BWhiteSmall $ABlueBig $BBlueBig etc..... The loops I don't have a problem with. But how do I... -
Help using variables in a reg. exp...
I want to do something like this... %jason = ( red => ((//^one/ and /two/) or (/^three/ and /four/)), green => ((//^five/ and /six) or (/^seven/ and /eight/)) ); foreach $key ( keys %jason ) { if $jason{$key} { do_stuff } } but that doesn't work...how do I get this... -
Spreadsheet::WriteExcel::Big makes my .xls bigger than necessary...
Yeah, I know that. What's I'm saying is that when you write with Spreadsheet::WriteExcel it makes the file huge. Then you open and save it in Excel and the files size reduces by A LOT. -
Spreadsheet::WriteExcel::Big makes my .xls bigger than necessary...
So I write a .xls using Spreadsheet::WriteExcel::Big and it's 25-MB. Then I open and save it, and it's under 500-KB. Wassup with that? Can I get perl to write the file in this more compact format? Thanks, Jason -
Help me use modules?
OK...som preogress...I had been running the script from within the EngInSite Perl Editor and I kept getting all the errors. Now, I tried to run the script from the command prompt in cygwin...and it worked. Can anybody explain what my problem is? -
-
Help me use modules?
I'm working on that right now...Is this something I'll have to do normally to use modules I install? -
Help me use modules?
So I installed the Spreadsheet::WriteExcel module from CPAN. I ran the script in the FAQ to show me which modules are installed, and it listed the Spreadsheet modules. When I try to the module, however, it doesn't work. I get this error message: Can't locate Spreadsheet/WriteExcel.pm in... -
Swith columns/rows in a tab delimited text file
THanks for all the help guys. -
Swith columns/rows in a tab delimited text file
I got it! It hit me last night. I am such an idiot. I guess this is what happens when you don't write any code for 10 years. For some reason I was stuck on working with the data as numbers, since it is all numbers. But then it hit me that I should just work with it as text. So I have one... -
Swith columns/rows in a tab delimited text file
Lets say 20,000 columns and 500 rows of data. I tried an array of ararys and it takes like 30 minutes. -
Swith columns/rows in a tab delimited text file
How can I switch the cloumns and rows of a tab delimited text file? I can't use an array of arrays or anything like that because there is a LOT of data in the file and it takes forever that way. I was think read a row, write it to the output file, then read a row from the input file, and add... -
One more...reading a file into an array/hash
Cool. What if there are two columns in the text file and I want the first one to be the values of the array. How do I encorporate the split command? -
Help me manipulate text files...
Wow, now that's a thurough explanation. Thanks for your time. I'm worried though that this hash may get too large for my computer memory. Should I be worried? -
One more...reading a file into an array/hash
I have a text file. 1 column, all numbers. I want to read the number on each row into an array. Isn't there some simple way to do it without a counter? something lie @myarray = <>; or something? What if there were two column in the data files, and the first way the key value. Thanks for...
