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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: josecervmon
- Order by date
-
Hardcoding Blank cells
Thanks Dale & Tony-- Well you guys can tell I'm definitely a beginner. Neither of these quite do the trick for me, what I really want is to get an actual BLANK cell back as I have other code that will manipulate these cells based on whether they are blank or not (from what you say Tony--this is...- josecervmon
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Hardcoding Blank cells
Hello- I'm looking for an excel function to hardcode a cell as blank. In particular I'm running into problems with the "If" function. For example, when I enter the following function: =IF(3=0,"yy","") (which evaluates to FALSE of course) the "" in the...- josecervmon
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Deleting Rows after a keyword
How about deleting a single row if a cell equals zero in a certain column? For example, I want to write a macro to delete all rows that where the cells in column "L" are equal to zero. Anyway to do this without using loops? Thanks- josecervmon
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
