Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formula/functions
I received a spreadsheet that someone wants me to help them with. The vba
code that runs when a button is clicked exports a range to a csv file. I entered the following formula into the first column so that it would enter a 1 only when something is entered into column N. This part works. =IF(N8<"",1,"") However, when I know export the data it thinks it should export all 92 rows because it thinks the formula is part of the data. How do I tell the code to NOT include the formula when it searches for a blank row? Thanks, I am thinking there is something simple I can enter to hide formulas from being seen... part of the code is below and I think it might be something I could enter here. If endRow = 8 Then For rowNdx = 8 To endRow inputRow = "" For colNdx = 1 To 24 If Cells(rowNdx, colNdx).Value = "" Then cellValue = "" Else cellValue = Cells(rowNdx, colNdx).Text End If inputRow = inputRow & cellValue & ";" Next colNdx inputRow = Left(inputRow, Len(inputRow) - 1) Print #fNum, inputRow Next rowNdx Else GoTo EndMacro: End If -- Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
Hiding functions | Excel Worksheet Functions | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
Hiding formula | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) |