Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Registrate date/time in a specific column for multiply selected rows

Goodmorning,

I like to get a macro that help me out;

In an excell sheet I have selected multiply rows which are not always near eachother like row 2 till 5 and with CTRL row 10 till 20 and with CTRL row 30 till 35.

Now I want to registrate the actual date/time for all those selected rows in column X

So..... for all selected/activated rows set in column X the actual date/time stamp.

Thats all :)


regards, Johan
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Registrate date/time in a specific column for multiply selected rows

Super thanks.

Other aditional item.

After selection the multiply rows I need to delete in the whole column "FA" the text 'xyz' if it is registrated allthere. The fields were this could be registrated has nothing to do with the selected records (in first place), but this selection has to stay for another step.

In steps;
- Select all rows of the selected cells.
- Delete the text 'xyz' (if there is) in all cells of column 'FA'
(keep the selected rows from the first step selected).

regards, Johan

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Registrate date/time in a specific column for multiply selected rows

Thanks(!!),

It deletes only 'xyz' in the selected rows and not in the complete column FA

regards, Johan


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default Registrate date/time in a specific column for multiply selected rows

Hi Johan,

Am Mon, 16 Oct 2017 05:39:11 -0700 (PDT) schrieb :

It deletes only 'xyz' in the selected rows and not in the complete column FA


change the code to:

Set myRng = Columns("FA")
myRng.Replace what:="xyz", replacement:=""


Regards
Claus B.
--
Windows10
Office 2016
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Registrate date/time in a specific column for multiply selected rows

YES !!!! THANKS.

Regards, Johan
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MsgBox if within selected rows a specific column is not filled in [email protected] Excel Programming 4 November 26th 16 08:24 AM
Change Event (How post Date/Time to Changed Cells Rows but different Column) [email protected] Excel Programming 7 August 19th 09 04:34 AM
How to multiply column and rows Ganesh Excel Discussion (Misc queries) 13 August 24th 08 01:15 AM
How to multiply rows to match the specific value in the row Paatu Excel Discussion (Misc queries) 3 October 5th 07 06:58 AM
In VBA, How to Refer to Cell In Specific Column But Selected Rows? PBJ Excel Discussion (Misc queries) 7 August 3rd 07 05:56 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"