No announcements
Found 2935959 threads
-
0 VotesUsing VBA in Excel, select a single column in an AutoFiltered range to enter a single value in each cell
update each visible cell in a single column so I know in future that this data has already been extracted. Background ...Answered | 7 Replies | 3987 Views | Created by DA74 - Thursday, June 14, 2012 10:36 AM | Last reply by DA74 - Friday, June 15, 2012 9:24 AM
-
0 Votes
VBA Control to select a single cell
Hi, I would like to have similar control like refedit but to enable the user to select a single cell only and after ...Answered | 3 Replies | 1151 Views | Created by Guy Zommer - Tuesday, December 24, 2013 1:52 PM | Last reply by Guy Zommer - Wednesday, December 25, 2013 1:33 PM -
0 Votes
Select a single cell in listview
Dear All, I am using the listview with C# in VS.NET 2005. I would like to select a single cell (not just cells ...Answered | 2 Replies | 6304 Views | Created by DLG007 - Friday, February 17, 2006 3:41 PM | Last reply by Mark Rideout - Saturday, February 18, 2006 2:03 AM -
0 Votes
VBA how to bold a single word in a cell?
Hello. I am trying to use VBA to set the font of a single word of the text contained in a cell to ...Answered | 3 Replies | 32904 Views | Created by cormanaz - Friday, February 18, 2011 4:54 PM | Last reply by Powergeek87 - Thursday, August 18, 2016 12:49 PM -
0 Votes
Select Single Column Value
) first and second column are self explanatory, in 3rd column I am storing the name of first column or 2nd ...Answered | 2 Replies | 4557 Views | Created by rt.garg1991 - Sunday, May 1, 2011 3:01 PM | Last reply by Sali SQL - Sunday, May 1, 2011 3:33 PM -
0 Votes
Update a single cell in Excel using sql
Hi Saritask, Updating a single cell in excel need to do some operations in advance.Your example does not ...Unanswered | 2 Replies | 940 Views | Created by Saritask - Wednesday, August 5, 2020 4:32 PM | Last reply by Echo Liuz - Tuesday, August 11, 2020 1:17 AM -
0 Votes
How to get a single cell value from Microsoft Excel in C#
Hi, I am using oledb connection to retrieve a single cell value from excel. How should I format my query string, none of these seem ... -
0 Votes
Refresh a single cell in a Datagridview
Hi there, I have a winform with a datagridview displaying ever changing data from a list of objects. It seems inefficient to refresh the ...Answered | 1 Replies | 5290 Views | Created by Jack McD - Sunday, November 4, 2007 12:59 AM | Last reply by DamPee - Sunday, November 4, 2007 9:56 AM -
0 Votes
Using Cell Value as the Cell Reference in a Range
next available cell in "PermData". B6 will return a value like K56 which would be the next cell i want to use. ...Answered | 1 Replies | 588 Views | Created by Qaspec - Wednesday, August 27, 2014 7:38 PM | Last reply by Hans Vogelaar MVP - Wednesday, August 27, 2014 8:49 PM -
1 Votes
Remove duplicate value in a single column
You need to split the column into individual components first using any split function available, select distinct set from it and then concatenate ...Answered | 6 Replies | 2595 Views | Created by Vick72 - Tuesday, October 16, 2012 7:22 PM | Last reply by CSharp Enthusiast - Wednesday, October 24, 2012 3:55 PM -
0 Votes
Refering to a single cell in a named range in a function
Sheet1 has a column named Age, hence Age is a range. In Sheet2 I can select a cell in any ...Answered | 2 Replies | 213 Views | Created by DiDoDe - Friday, August 11, 2017 2:43 AM | Last reply by DiDoDe - Friday, August 11, 2017 3:19 PM -
0 Votes
Password Protect a single cell in excel using VB.NET
Changes Group-> Allow Users....] Excel offline help is enough to give you a good start.Answered | 4 Replies | 4888 Views | Created by Paul.Matipano - Thursday, January 3, 2013 7:48 AM | Last reply by RanceL - Friday, January 11, 2013 2:57 AM -
0 Votes
Updating a single Excel cell using SSIS
Hello, I am using a below code for updating a Excel tab using SSIS, but getting error "[Execute SQL Task] Error: Executing the ...Unanswered | 1 Replies | 1454 Views | Created by Ved_Prakash_ - Thursday, September 8, 2016 9:44 AM | Last reply by AV111 - Thursday, September 8, 2016 12:57 PM -
0 Votes
capture a value from a cell in excel with vba
but I need to add one more condition which is the value of a cell which is in the "CL" column, but the row varies depending on ...Answered | 4 Replies | 2907 Views | Created by palermo_software - Thursday, June 28, 2012 8:36 PM | Last reply by palermo_software - Tuesday, July 3, 2012 1:08 PM -
1 Votes
how to run vba with a single cell value.
Hi, I want to run vba with changes in cell A1 with a drop down selection change but with out Worksheet_SelectionChange . Is it possible ...Proposed | 1 Replies | 375 Views | Created by drsantoshsinghrathore - Thursday, October 22, 2015 3:20 PM | Last reply by Hans Vogelaar MVP - Thursday, October 22, 2015 3:33 PM -
0 Votes
Excel VBA - Cell color in Column C depends on value in Column A and Column B
If you have Excel 2007 or later, the Conditional Formatting dialog will display the formula for the first cell of the range it applies to, even if you ...Answered | 3 Replies | 3471 Views | Created by CSharpNoob2011 - Saturday, April 14, 2012 9:49 PM | Last reply by Hans Vogelaar MVP - Sunday, April 15, 2012 8:49 AM -
0 Votes
Color a single cell in a Datagridview
You can use cell-formating event to do this. If the value is different with the provious one, then change the cell style.Answered | 3 Replies | 2779 Views | Created by domore87 - Wednesday, January 20, 2010 11:28 PM | Last reply by aniedv - Wednesday, January 27, 2010 10:04 AM -
0 Votes
Multiple Hyperlinks in a single cell
Maybe you can cheat. You can put a couple of rectangles in the cell. And assign a different hyperlink to ...Answered | 4 Replies | 7367 Views | Created by bhughes1231 - Monday, December 27, 2010 10:20 PM | Last reply by Dave Peterson - Tuesday, January 4, 2011 11:10 PM -
1 Votes
How to copy/paste single cell from SQL data to single cell in Excel
it will import each cell into single one in Excel. Or you can try to select data directly into ...Answered | 1 Replies | 1426 Views | Created by Kameron Espenson - Tuesday, September 17, 2013 2:23 PM | Last reply by Brandon Myers - Tuesday, September 17, 2013 2:40 PM -
0 Votes
How to delete formula in a single cell in exceldelete
VBA. Clearing a Cells/Range using Clear Method This method will clear the range of cells including ...Answered | 1 Replies | 290 Views | Created by Bleau S Bryant - Thursday, June 9, 2016 2:57 PM | Last reply by Deepak Saradkumar Panchal - Friday, June 10, 2016 5:46 AM - Items 1 to 20 of 2935959 Next ›
No announcements
