copy checkbox string and paste it in excel sheet

NoSparks · #1 10-27-2015, 07:43 AM

Try this using F8 to step through the code and see where you would be putting the "X"

Code:

Sheets("Testing_Sheet").Cells.Find(test_info(eqp_count - 1).vis_tests(looper), LookIn:=xlValues).Select

think you'll need to be including an Offset to position the "X"

MOHAMMEDSALMAN · #2 10-27-2015, 10:53 PM

Hi,

Thanks a lot. Its working. The only minor problem is that I want to put "X" in column B but its getting placed in column A.

How can I define column B in the following code. The following code worked properly.

Code:

Sheets("Testing_Sheet").Cells.Find(test_info(eqp_count - 1).vis_tests(looper), LookIn:=xlValues) = "X"

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel copy two numbers between specific column and paste in next sheet	visha_1984	Excel	1	12-26-2014 07:59 PM
Want to change Macro to copy and paste data to new sheet	Vortex69	Excel Programming	0	12-23-2014 09:53 PM
Find Results in excel copy the rows to another sheet	khalidfazeli	Excel	2	02-06-2013 09:38 AM
How to Copy data from Outlook mail and Paste it in a Excel sheet?	padhu1989	Outlook	0	09-11-2012 04:07 AM
Word - Calculate and paste values from Excel sheet	Augf87	Word	1	07-06-2009 10:26 AM