I have a macro that rolls through an Excel Sheet, formatting another sheet into the appropriate output format. However, the original sheet has text boxes that I want to delete. These text boxes are not always the same, and so I obviously can't just record a macro where I go around deleting...
Thanks for all your help, I got it to go, here is the winner................
Private Sub DeleteZCells_Click()
Dim c As Range
With Worksheets("Sheet3").UsedRange
Set c = .Find("z", LookIn:=xlValues)
If c Is Nothing Then
MsgBox "Not found!"...
These work great for clearing the contents, but the cells still remain. I need to delete the cells and shift the others up. Thanks for your help so far, do either of you know how to reach the next step. I have tried substituting delete commands, but I always get this message, which is the...
I have been trying to delete individual cells containing the value of "z" from my spreadsheet using VB. I have been using the code I have found on this website as a base (it is all for deleting entire rows), but for some reason I can't make the conversion work. Can someone please...
Is it possible to create a Visio Document, in this case a site map, based on dimensions stored in an excel spreadsheet. I would like to create an application that automatically sizes the layout based on the dimensions of the building I am planning for. I also would like to create stencils that...
I have developed a very simple database to log in questions and hyperlink to the documents that contain the answers. Very Simple, however, in order to make this database worth using, it has to have a keyword search function. The keyword search is important because users will log their...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.