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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copying a range to a new worksheet
What's the best way to copy the usedrange of a worksheet to a new worksheet created for this temporary purpose? I've tried the Copy function, if this is correct I can't seem to get the syntax right.....any help appreciated. Also I try to save the worksheet as a CSV file and it saves the entire...- Tom21
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Checking for numeric values
An easy one for you pro's out there..... How do I go about checking for a 'numeric value only' in a cell, even if the cell is text based? Cheers, Tom.- Tom21
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Deleting row in excel causes rows to shift up - work around?
When I delete an excel row in a for loop the row gets deleted but the row under it is then shifted up to compensate. This means that on the next loop around I'm looking at what is essentially two rows ahead originally..... What I need is something that lets me go back one in the loop to get the...- Tom21
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
