Tuesday, December 31, 2013
Wednesday, December 04, 2013
Sub EraseEmptyRows()
Dim rw, i
For i = 1 To 5
' Here the loop is up to 5 meaning the maximum number of rows with no data would be 5
' Increase this number when necessary
For Each rw In Worksheets(1).Range("A1:A50").Rows
' Sweeps all cells in the range. Change the range when necessary
If (IsEmpty(rw.Cells(1, 1))) Then rw.Delete
' Erases if the cell is empty
Next rw
' End for rw loop
Next
' End for i loop
End Sub
Dim rw, i
For i = 1 To 5
' Here the loop is up to 5 meaning the maximum number of rows with no data would be 5
' Increase this number when necessary
For Each rw In Worksheets(1).Range("A1:A50").Rows
' Sweeps all cells in the range. Change the range when necessary
If (IsEmpty(rw.Cells(1, 1))) Then rw.Delete
' Erases if the cell is empty
Next rw
' End for rw loop
Next
' End for i loop
End Sub
Posted on 7:53 PM by Erdem
Public Sub Add_Data_to_rows()
' Procedure to add data to rows
' Use this to understand how .Rows work
Dim rw
' Initiate a variable to use as rows object
For Each rw In Worksheets(3).Range("A1:C100").Rows
' Select each row starting from 1 on page 3
rw.Cells(1, 1).Value = "ABC"
' Set the value to "ABC"
Next rw
' End for loop for rw
End Sub
' Procedure to add data to rows
' Use this to understand how .Rows work
Dim rw
' Initiate a variable to use as rows object
For Each rw In Worksheets(3).Range("A1:C100").Rows
' Select each row starting from 1 on page 3
rw.Cells(1, 1).Value = "ABC"
' Set the value to "ABC"
Next rw
' End for loop for rw
End Sub
Posted on 1:18 PM by Erdem
' Function to erase empty rows in excel
' !!Currently it checks second work sheet!!
' Checks the first cell and erases the entire row if the cell is empty
'Simply copy this macro to your excel file
Sub EraseEmptyRows()
Dim MyCheck, rw, this, i
For i = 1 To 50
' Scan through rows 1 to 50
For Each rw In Worksheets(2).Cells(i, 1).CurrentRegion.Rows
' Select each row starting from 1 on page 2
this = rw.Cells(1, 1).Value
' Copy the value of A cell
MyCheck = IsEmpty(this)
' Check if the cell is empty
If MyCheck Then rw.Delete
' If it is, erase entire row
Next rw
' End for loop for rw
Next i
' End for loop for i
End Sub
Posted on 8:52 AM by Erdem
Thursday, November 14, 2013
Thursday, October 31, 2013
When you create an app for windows phone, Visual Studio adds frame rate counters to visualize rate properties. To disable those, we need to open App.xaml.cs and need to set a variable to false as seen below:
All required information about these counters can be found at the address:
http://msdn.microsoft.com/en-us/library/windowsphone/develop/gg588380(v=vs.105).aspx
// Set it to for not to display the current frame rate counters. Application.Current.Host.Settings.EnableFrameRateCounter = false;
All required information about these counters can be found at the address:
http://msdn.microsoft.com/en-us/library/windowsphone/develop/gg588380(v=vs.105).aspx
Posted on 6:45 PM by Erdem
http://stackoverflow.com/questions/11914562/wp7-change-application-name
You change the Title of the app in the file called WMAppmanifest.xml. Inside the App xmlns-tag theres a field for Title.
You change the Title of the app in the file called WMAppmanifest.xml. Inside the App xmlns-tag theres a field for Title.
Posted on 6:44 PM by Erdem
Sunday, August 04, 2013
In the following example, when the user hovers the mouse over the button, the form expands in y direction. When the user clicks on the button, the text on the button changes.
int size1 = 400;
int adder = 50;
public Form1()
{
InitializeComponent();
this.button1.Text = " Change Item ";
this.button1.Dock = DockStyle.Bottom;
this.button1.Click +=button1_Click;
this.button1.MouseHover += button1_Click_F2;
this.Controls.Add(this.button1);
this.dataGridView1.Dock = DockStyle.Top;
this.Controls.Add(dataGridView1);
this.Size = new Size(400, 200);
}
private void button1_Click(object sender, EventArgs e)
{
this.button1.Text = " Button1 Click is called ";
}
private void button1_Click_F2(object sender, EventArgs e)
{
this.Size = new Size(400, size1);
size1 = size1 + adder;
}
Posted on 9:18 AM by Erdem
Subscribe to:
Posts (Atom)
Categories
Blog Archive
-
▼
2014
(22)
-
▼
January
(22)
- What is Asynchronous Programming?
- Quality C# (C sharp) Code Examples
- Windows phone emulator not connected to internet
- Using ListBoxes with Buttons and Adding Many Buttons
- Data Binding with a Slider
- Data Binding with Radio Buttons and Two Way Binding
- Data Binding to Control Multiple Objects - Part 1
- High End Windows 8 Phones
- Adding Event Handlers to Controls
- Stack Panel Experiments Part 1
- Using Grid in Windows Phone 8 Development Part 3
- Using Grid in Windows Phone 8 Development Part 2
- Using Grid in Windows Phone 8 Development Part 1
- Simplest Data Binding for Windows Phone 8
- Very simple code using generics
- Casting nedir?
- Generics nedir? Basitce ne ise yariyor
- Windows Store trends, interesting data showing wha...
- How to submit your app to windows app store
- Boxing and Unboxing
- Using Indexers
- Setting logo, publisher name, tile image and some ...
-
▼
January
(22)
Popular Posts
Powered by Blogger.




