Search results for query: *

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

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

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

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

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

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

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

Can sombody explain keys to me? I get that keys %hash returns an array with the key values. But how do I use keys when I have a hash of hashes? How do I find the second set of keys? I'm very new to perl so please be simple in you responses. Thanks, guys.

So I have data (in a file) like this: A1 F 1 G 2 H 3 A2 F 2 G 5 H 9 B1 F 6 G 3 H 7 B2 4 0 1 Ans I want to switch it up so that it's like this: A1 A2 A3 A4 F 4 6 3 5 G etc. H What's the best/most efficient way to do this? I figure I could loop over the...

Can somebody explain Sheets.Activate and Sheets.Select to me? WHen to use, what they do, etc? And when can I use Cells(1,1) and when do I have to use Sheets(1).Cells(1,1)? This is confusing me. I wrote this code, and it worked... Sub doit() Sheets(1).Activate If Cells(1, 1) = 1 Then...

So I am writing a function. I want the value of the function to depend on the Row/Column location of cell in which the formula is being evaluated (so if I put = MyFunct() in cell C4 I want the returned value to depend on 3 and 4) I know I could use row() and colun() as arguments to the...