For Each Row - Do Stuff
Aug 8, 2007I have a script that i want to run for each row on my worksheet, but don't know the correct way to do a foreach using VBA.
For Each row ...
Do this code
... end for each
ADVERTISEMENT
Protect My Stuff
Jun 1, 2009my worry now is to protect my program from being played with as a lot of people ,some not so bright ,have access to my sheet can i protect my sheet and still have the macros function.
View 9 Replies View RelatedInserting Row With Stuff On Clipboard?
Dec 14, 2011Sometimes I need to copy something to the clipboard, then go to another sheet (or somewhere). When I get "there", I sometimes want to insert rows, without "inserting cut/copied cells" . . . . So I end up saving the worksheet to clear the clipboard, then inserting my rows.
Can I insert blank rows while maintaining my clipboard?
Dropdown List Or Autofill And Stuff?
Feb 19, 2014I have a list of model numbers that corresponds to part numbers i.e:
model number
part number
abc
123
def
456
[code]....
I can type in A2 = ab and it autofills the model number abc, and have B2 automatically have the part number which is 123 filled in as well.
Read Stuff From Closed Files
Dec 18, 2007I would like to create a single excel file, which is composed by fragments of different (closed) excel fies (it should take some data from the files).
VBA Stuff- Weight Watcher Spreadsheet
Nov 4, 2008I have a Weight Watcher spreadsheet. I enter the Calories, Fat and Fiber and I get the # of points for that food. Then I keep put those points into the lower part of the spreadsheet where I track what I eat, and Excel does my simple math for me. What I want to do is keep a list of my foods, and their point value in my spreadsheet. I would like to be able to put the food name in Cell A1, the WW points in BI, and then be able to click a button with a macro that takes those two pieces of data and add them to bottom of my food list. I don't have a food list yet, I would assume I can just put it on sheet 2. I then want to be able to use lists in my cells to choose the food in the future. I need to be reminded how to make "dynamic named ranges. Today, I just need to know how to write the macro to copy and paste those two cells in the first open row at the bottom of my food list.
View 9 Replies View RelatedPrint Preview Shows 2 Pages But Only Have Stuff On One
Apr 29, 2012When I view my page on print preview it shows 2 pages but I only have stuff on one page the second page shows 2 border marks but when I go to erase them I can't find them. Is there some way that I can find them other than look at page after blank page.
View 4 Replies View RelatedSpeeding Up Macro Process (Graph Algorithm Stuff)
Jul 7, 2009i'm working on floyd algorithm macro for a project,
problem is, the spreadsheet matrix is huge, it's a 1043 x 1043 spreadsheet
And this is taking wayyy too long, i've been waiting for almost 2 days already..
here's the file :
http://ifile.it/6v2j39f
(You start the macro using "run" command in "input" sheet)
So is there any way to speed it up?
Or if anyone got a supercomputer, could you help me process this? :p
I'm thinking about changing the 10^5 value into infinite value, but i can't find a way to display infinite value..
And here's some reference for Floyd's algorithm,
http://ifile.it/12p5zle
I have tried to split the algorithm to make it process one iteration at a time, but i've been waiting like 2 hours with no result,
and that's for 1 iteration, can't imagine how long it takes for 1043 iterations
You can do this by deleting the.
Excel 2007 :: Macro To Delete All Data Before Pasting In New Stuff
Nov 25, 2013I am using Excel 2007 and have a simple enough macro to paste data in to another sheet - simple is what I do best.
Sub Macro1()
'
' Macro1 Macro
With Sheets("data")
.Range("B3").PasteSpecial xlPasteAll
End With
End Sub
I am wanting to change this so that before it pastes any data into B3 it will delete all data from B3:AE22.
I have had a look around and found plenty to delete full rows or worksheets but not just to delete the data in those cells.