Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Blank Cells
I have a code that copies a large range of cells from one workbood to
another, the problem is when I do this all blank cells when transfered = 0 . Does anyone know what line of code will skip the blank cells of have them transfered over blank. Thank you to anyone that helps. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Blank Cells
Do you mean by linking
Instead of =Sheet1!A1 use =if(sheet1!A1="","",Sheet1!A1) -- Regards, Tom Ogilvy "Benz" wrote: I have a code that copies a large range of cells from one workbood to another, the problem is when I do this all blank cells when transfered = 0 . Does anyone know what line of code will skip the blank cells of have them transfered over blank. Thank you to anyone that helps. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Blank Cells
No im not using a formula..... im refereing to a workbook other then the main
source wookbook. Heres what I have. Sub File_In_Local_Folder() Application.ScreenUpdating = False On Error Resume Next 'Call the macro GetRange GetRange "C:\Documents and Settings\home\Desktop\taskTEST", "TASKS", "A1:AB71", _ Sheets("Sheet3").Range("A1") On Error GoTo 0 Application.ScreenUpdating = True End Sub "Tom Ogilvy" wrote: Do you mean by linking Instead of =Sheet1!A1 use =if(sheet1!A1="","",Sheet1!A1) -- Regards, Tom Ogilvy "Benz" wrote: I have a code that copies a large range of cells from one workbood to another, the problem is when I do this all blank cells when transfered = 0 . Does anyone know what line of code will skip the blank cells of have them transfered over blank. Thank you to anyone that helps. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Blank Cells
I suspect your GetRange function is some modification of John Walkenbach's
getvalue function: http://www.j-walk.com/ss/excel/tips/tip82.htm The problem is the same as the linking problem I described. However, I doubt there is a simple fix you can use such as the one I have shown. You could have your code put hard coded linking formulas into the spreadsheet using the IF construct I have shown, then replace those formulas with the results returned. -- Regards, Tom Ogilvy "Benz" wrote: No im not using a formula..... im refereing to a workbook other then the main source wookbook. Heres what I have. Sub File_In_Local_Folder() Application.ScreenUpdating = False On Error Resume Next 'Call the macro GetRange GetRange "C:\Documents and Settings\home\Desktop\taskTEST", "TASKS", "A1:AB71", _ Sheets("Sheet3").Range("A1") On Error GoTo 0 Application.ScreenUpdating = True End Sub "Tom Ogilvy" wrote: Do you mean by linking Instead of =Sheet1!A1 use =if(sheet1!A1="","",Sheet1!A1) -- Regards, Tom Ogilvy "Benz" wrote: I have a code that copies a large range of cells from one workbood to another, the problem is when I do this all blank cells when transfered = 0 . Does anyone know what line of code will skip the blank cells of have them transfered over blank. Thank you to anyone that helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to ignore blank cells | Excel Discussion (Misc queries) | |||
ignore cells that are blank | Excel Discussion (Misc queries) | |||
Ignore Blank or 0 cells | Excel Worksheet Functions | |||
How to ignore blank cells | Charts and Charting in Excel | |||
how do you ignore blank cells | Excel Discussion (Misc queries) |