|
jakeblanchard (November 30, 1999 at 12:00 am)
@ForevaNewsh You could count the number of sheets in a workbook and then name the new sheet based on that count. To count the sheets, use the VBA functionWorksheets.Count
ForevaNewsh (November 30, 1999 at 12:00 am)
I'm looking for a macro code that would help me create a new sheet AND call it ''week1''. Then, next time you click on the macro it would create another new sheet and call it ''week2'', then ''week3'' and so on.. could you help me with that please? thanks.
jakeblanchard (November 30, 1999 at 12:00 am)
@xXSparky117Xx Here is an example of an array in VBA:Dim MyStuff(1 to 5) As LongDim ii As IntegerFor ii = 1 To 5 MyStuff(ii) = iiNext ii
xXSparky117Xx (November 30, 1999 at 12:00 am)
How would I modify the formula for an array with VBA? I've got almost everything I need figured out but this.
jakeblanchard (November 30, 1999 at 12:00 am)
@RandyLB2 What you want to do is write a loop to read each cell value into a string, delete the last 3 characters, write the new result back to the cell, and then go on to the next cell. This is not too difficult. To delete characters from a string, do a Google search forAutomate Excel » VBA: Remove Characters from Left or Right Side
RandyLB2 (November 30, 1999 at 12:00 am)
How do I create an Excel macro that would allow me to edit the contents of a cell by deleting the last three characters and move to the next cell down in the same column and delete the last three characters in that cell and then repeat itself to the end of that column?
davobircko (November 30, 1999 at 12:00 am)
People who are familiar with programming tend to pick up other programming languages more easily so yes its a good intro for them. There are lots of free resources out there to start learning VBA and macros. If you haven't got the time you can get help from people like imsx _com _au to turn a mini project around for you.
37no37 (November 30, 1999 at 12:00 am)
Pickover posed a problem at archery by the numbers. This is really a combinatorial problem -- given the 24 numbers taken 5 at a time, which unique combinations add up to 200 generate a list how to do this in excel 2003. help please.
MarinaInCali1 (November 30, 1999 at 12:00 am)
Useful but the sound is too low
rabidbeavir (November 30, 1999 at 12:00 am)
@whatever3009 try harder. |
