Excel usedrange not updating visual basic validating odd number

09 Feb

I use Excel 2010, any suggestions would be appreciated. Find("*", searchorder:=xl By Rows, Search Direction:=xl Previous). Column Else Last Row With Data = 1 Last Column With Data = 1 End If '================== ' Step 3 '================== 'Clear the data 'Research: Sometimes these clear commands don't work. If value = 1 there's no data, only a header Range(Range To Clear). This clears the data and replaces it with "" just fine so I know it's able to read the range correctly. It appears the only thing I can do is read the value of the cells and change the value of the cells. We also share information about your use of our site with our social media, advertising and analytics partners.Sub Clear Save(target Sheet As String, Optional Column To Search As String = "C") 'This code will clear the data in the sheet and prepare for new saved data. Determine which sheet is being requested to be cleared '2. Also, changing the font and background color is ignored. 3 ) Bear in mind that VBA has a “Memory” of the last Used Range. The intriguing thing about this problem is that I can manipulate the values in the range, so Excel clearly knows the range exists. (Regardless of specified ra ( where i tried to answer my own question!! Deleting rows seems a much more well behaved way to “Clear” Data . Maybe if you uploaded a file for example send over this free thing: Box Net, ( Remember to select Share after uploading and give us the link they provide. But unfortunately none of these commands work the second time this is used. Special Cells(xl Cell Type Blanks) Only works on Used Range? This also works if they are deleting data, but that’s not common in this type of situation.

Normally, this works, but there are circumstances when this code (see step 3) does not clear the contents. Clear End If End Sub Last Row With Data = Target Worksheet. Find("*", searchorder:=xl By Rows, Search Direction:=xl Next). Instead it read the last row as 1 and the last column as 1. Similarly some things work using the last Used Range and some things automatically update or refresh this memory so that they or following commands looking to find last rows or columns, etc. It's seems sloppy to code this way but for now it works. But you will also see that I did not really get to fully understand it. If I manually removed all entries I then had no Used range. - As you will see from my ramblings at that Thread, there were exceptions to the rules. Up until now most of my Googling just gave answers like “VBA” behaves badly or does not handle well or consistently it’s memory of The last Used Range.” Not much help to us! Here was one google: Excel Developer Tip: Automatically Resetting the Last Cell Alan. Another last “Wild” thought – If you are looking / playing with “empty cells” you may find that looking for “” would give different results as looking for .Last August, we announced the availability of the Excel REST API on Microsoft Graph.We continue to explore opportunities for new scenarios and functionality that allows for deeper and richer integration with Excel workbooks.This stubbornness usually happens when choosing a custom number format.You can update it by double-clicking the cell, making no changes, and then press Enter, but this can be very tedious.